insert remote data into access table

[dinger2121]

Hello,
I am hoping to query an external table and then insert that data into an access db. I am able to connect to the remote database (it is informix) using dsn. I then would like to insert into my access database. I am using the following query -

insert into temp select remoteTable.field1, remoteTable.field2....from remoteTable

I am getting an error that temp does not exist in the database. I have created a temp table in the access database that matches the data I am trying to import. I am assuming that the query is looking for the temp table in the remote database.

Does anyone know how I can accomplish this?
Thanks

carl
MCSD, MCTS:MOSS

 

[dinger2121]

I was able to accomplish what I needed using a pass through query in conjunction with an append query.

Thanks

carl
MCSD, MCTS:MOSS