Using Make Table in Another DB

[Mark]

I have a query that pulls about 1/2 million records that I
want to dump as a reference table. I can write a query to
create a table and that works fine, but when I try to
modify it to an append query, I get a message Record
Deleted when the query runs, and no records are appended.

Now I know I could run the Make Table and then append the
results, but with that takes twice as long, and causes
bloating in my front end that I would rather avoid.

Is it possible to write VB code that makes a table into
another database?

Thanks

Mark

 

[Chris Nebinger]

Yes you can. The format is


Insert Into tablename (fieldName) in 'C:\dummy.mdb"
Select Fieldname from Tablename



Chris Nebinger

 

[Mark]

Thank you Chris.

Have a great day.

Mark

-----Original Message-----
Yes you can. The format is


Insert Into tablename (fieldName) in 'C:\dummy.mdb"
Select Fieldname from Tablename



Chris Nebinger


.