No, I haven't parsed it with word yet. May be the XML route would be an easier option to you.

Cheers!

_________________________
- Vijay G
Strive for Perfection

thanks for all your help!

I'm in need of the same sort of anwser. I need to import a csv file into an Access 2000 DB using ADO or other connection object. I do not have access running on the machine where the access db is hosted, so the (transferText) object doesn't work.

Any help on this would be great! Also the csv file is comma sep. and no header line.

Hi jeffbarclay,

You could take a look at the thread posted in one of my posts down this thread. That would help you read the text/csv file and store them into variables. But you got to code to write that into database. You may post here if you have any queries.

Also you can post the details on how the data is stored in the CSV file. (number of columns, load of data in that, does one line refer to a row in the database?, etc...)

Cheers!

_________________________
- Vijay G
Strive for Perfection