Creating a seperate database in VBA

R

Ryan

I was wondering if there was a way to create a seperate
database in VBA code. What I'm wanting to do is create
the database, then populate it with certain items using
the TransferDatabase method. Any suggestions are welcome.

Thanks,
Ryan
 
C

Cheryl Fischer

This can be done using the CreateDatabase (DAO) method. Check it out in
VBA Help for detailed information.
 
R

Roger Carlson

On my website, see sig below, is a small sample database that does just
that. Look for: "ImportToTempDatabase2k.mdb", which creates a temp
database, exports and empty table to it, relinks the table back to the main
database, then uses this temp table for importing data. This is done to
eliminate the bloat that can occur when data is imported to a native temp
table.
 
Top