ADO recordset

[matthooper]

Hi,

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

[matthooper]

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.