Create Table from Pass-Through

[ks1392]

Hi, I'm running a pass-through query against an Informix db and I want to create a table in my Access DB from the results. I know I can't use the INTO command since it's an Access command, and I'm not sure how else to accomplish this. Anyone had experience with this?

 

[tlbroadbent]

In Access you can use the pass-through query as the source for a make table query. Open new query and select the pass-through query from the Showe Tables dialog. Select Query | Make Table Query from the menu. Type the new table name. Select the columns for the new table. Then run the query.

The SQL would look like the following, though you might list specific columns.

Select QryPassThrough.*
Into NewTable
From QryPassThrough; Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[ks1392]

Hey, thanks a lot, that's exactly what I needed. I didn't even think to use the query as my source.