By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

maketable query and non-local database

P: n/a
Greetings all,

I have a split database with a number of maketable queries.
Up to now, these have been creating the associated table in the local
database
but now I want them to create the table in a specified destination database
(this may vary).

Rather than hand-editing each query, how do I change the destination
database of each query programatically?

My first though was to update the "Destination Database" property, as
displayed in the Query Properties popup.
However, I can't seem to locate where Access stores much of the information
displayed in this popup.

Analyzing the SQL property seems to show that the SELECT..IN..INTO is always
on the first line (the second being the FROM clause).
So, if I remove any present "INTO '...'" text from the end of the first line
and
append the desired destination, would work?

I'd rather use a more elegant method, but if this works, so be it.

Suggestions welcome.

Regards, Graham

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You should be able to use something like this:

SELECT MAIN.Id, MAIN.Name, MAIN.Publisher
FROM MAIN In "C:\Documents and
Settings\user\Desktop\Orange\RawImport1.mdb"
WHERE (((MAIN.Name) Like "C*") AND ((MAIN.Publisher) Is Not Null));

Oh hell, I'm so stupid. How about just linking to a new database (or
updating it) and then you can just query the linked tables....
otherwise, you'll have to edit all your SQL statements the hard way...
very ugly.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.