Re: Create Table in External DB

Tech-Archive recommends: Speed Up your PC by fixing your registry


In design view, drop down the Query Menu, and select
Make Table query. On the form, select the radio
button for 'another database'.

You get sql like this:

SELECT INTO fred IN 'freddd.mdb';

(david)

"kremesch" <kremesch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:090BBAFD-EDA7-47CC-84E8-557C9BFF69B4@xxxxxxxxxxxxxxxx
>I understand how to use a query to create a table.
> What I'd like to know is can I use a Create Table query to create a table
> in
> another database other than the one I'm in?
>
> What would be the corrent layout of the context if this is possible?


.

Quantcast