Using Make Table in Another DB

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
Yes you can. The format is


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



Chris Nebinger
 
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


.
 
Back
Top