CSV files

[JIM.H.]

Hello,

I need to reach some CSV file in access module and process
the data. I was thinking if there is a way to create a
link to files and use them as tables. Can I do that?
Thanks,
Jim.

 

[Ted]

You can link to text files similar to the way that you
would link to an Excel table or a table in another Access
Database (for my version of Access, I just right-click in
the tables area of the database and choose "Link
Tables..."). Then, you can work with the linked table
information as if it were a table in your database.

I believe that you should be able to do this through code
using the TransferText Method. This will be much easier
if your csv file will always be the same format, because
you can set and save the import specification ahead of
time (when importing manually using the wizard, click on
the Advanced button and then the "Save As" button to save
the currently defined specs). Then, list the name of the
specification in the TransferText method. Otherwise, if
the format will vary, the file will be imported using
Access defaults for things such as field types.

Hope this helps.

-Ted

 

[Roxie Aho]

-----Original Message-----
Hello,

I need to reach some CSV file in access module and process
the data. I was thinking if there is a way to create a
link to files and use them as tables. Can I do that?
Thanks,
Jim.


.

To link to a CSV file go to File, Get External Data, Link
Tables and select Text Files from Files of Type. A Wizard
will walk you through the link.

Remember, when you Link, any changes you make in Access
are made in the other file, and vice versa.

Roxie Aho
roxiea at usinternet.com