How do I run a query on Access?

[WALoeIII]

I have a query that I'd like to run, I dumped this from my MySQL.

CREATE TABLE News_Authors (
   author_id int(4) NOT NULL auto_increment,
   username varchar(255) NOT NULL,
   password varchar(255) NOT NULL,
   author_email varchar(255),
   author_name varchar(255) NOT NULL,
   PRIMARY KEY (author_id)
);

CREATE TABLE News_Stories (
   story_id int(4) NOT NULL auto_increment,
   story_date timestamp(14),
   author_id int(4) DEFAULT '0' NOT NULL,
   story_title varchar(255),
   story_body text,
   PRIMARY KEY (story_id)
);

I want to just copy and paste the sql into something, but I can't find where!

I know this is a really basic question and it is probably blaringly obvious but I can't seem to find it!

[westmich]

Open Access and create a new table without the wizard. You should what looks like a design view. In the upper left corner is an option for the SQL view. Paste your code there, although, you'll want to do each of those two blocks in a seperate table since they create their own table.

You may also be able to do the same thing from the SQL view of the query page.

[hillsy]

So you want to run that SQL in Access?

1) Go to the "Queries" tab in Access
2) Create a new query in Design View
3) When the Query Designer comes up (looks like a horizontally split window), cancel out of opening any tables and go to View --> SQL View
4) Paste your SQL into the editor

This is how you could do it under Access 97 anyway

[platinum]

Yeah, wot hillsy said
Click Queries,
create new query,
right click somewhere in the new window and select SQL view and copy and paste right there

[-TheDarkEye-]

Originally posted by westmich
Open Access and create a new table without the wizard. You should what looks like a design view. In the upper left corner is an option for the SQL view. Paste your code there, although, you'll want to do each of those two blocks in a seperate table since they create their own table.

You may also be able to do the same thing from the SQL view of the query page.

there is no sql view for tables. he would have to run this as a query.

[WALoeIII]

This is alot more complicated than it should be..

[wdmny]

A much simpler method....... under the Enterprise Manager in SQL Server, Export your database (or choose specific tables) to an Access database.

[hillsy]

What's the problem with running this as a query?

[westmich]

Originally posted by -TheDarkEye-


there is no sql view for tables. he would have to run this as a query.

My mistake

This is alot more complicated than it should be..

I don't think it could much simpler then cutting and pasting.