SELECT INTO using ODBC?

[RJN]

My SELECT statement is pulling from my external data source. I want the selected records to be imported to my local access MDB into a table I have already set up. How would I let access know which table is local/external in my query?

 

[KeithG]

Are you using a pass through query? If so you will have to create a seperate Append query from your PT query to append the record to your table.

 

[RJN]

Works like a charm. Sometimes I don't think outside the box enough.

Thanks

 

[KeithG]

Glad it worked! You need to use the JET database engine to insert the records from the ODBC data source.