MAKE TABLE INTO FROM DB A INTO DB B

[jadams0173]

After lots of head banging I'm stuck once again. I'm trying to run a make table query in access, with an unlinked SQL table and insert the new table into another access db.

With the following if I do show tables I can see all the tables on the server. I chose my table and select the fields. When I run the query I get prompted for a paramater and I don't know why. If I make it a regular select query I still get prompted and if I press ok I get the a table structure with no data but all the records in the table.

SELECT dbo.V_BOM.PARENT INTO TEST IN 'c:\temp\db1.mdb'
FROM dbo.V_BOM IN '' [ODBC;DSN=CLT;Server=SQL1\P1;Database=EXTRACT;Trusted_Connection=yes];

 

[jadams0173]

I finally found the answer....thanks all!