p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_access thread: importing programatically


Message #1 by "mike Wilson" <chopswil@a...> on Wed, 6 Dec 2000 21:32:15 -0000
Best approach I know is to create a ODBC Text Driver
for the CSV file

Then well you can either import or better link to the
text source. Set Up Queries Reports Forms (read only)
whatever

You have to define your ODBC driver with a schema.ini
file 

this is a text file.

If you wish to be fancy you can create this schema
from
a access table of fields and types writing and or over
writing the schema for the source file.

Using the ODBC text driver approach means that if the
source changes to another ODBC source you existing
Forms Reports Queries will all continue to work.!!


  Return to Index