How can I use current db to import data to external db

[CT]

How can I use current database to control/initiate import
of text file to external database? Current database has
all the logic but due to size issues I want to store
imported data in external database without the
data "touching" the current database in order to prevent
growth. At that point I will link tables.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there is a small Access sample
database called: "ImportToTempTable.mdb" which illustrates how to do this
for precisely the reason you listed.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L