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

ADO recordset

P: 37

I have a make table query and the syntax seems to be fine but I have no idea where the table has been created?!

sql statement: "SELECT field, field1, etc, etc INTO temptable FROM linkname.dbname.dbo.table;"

You may look at that and think why on earth I would want to do that but the ado connect connects to one sql server and then that links to another sql connection. To make the next query easier i want to create a local table to do links with.

Can anyone tell me where the table has been created
May 22 '07 #1
Share this Question
Share on Google+
1 Reply

P: 37
Im guessing no one knows the answer - its okay - i used append instead to copy the data to a local table - did the work and then delete all the data from that table to start the process again.
May 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.