Import Class

I have used the import class module from
http://www.mvps.org/access/modules/mdl0057.htm.

This reads the file correctly and is half of what I need, Can anyone
give me any tips/hints on appending the data to a table?

Basically I need to import all data to tblNewVendors, also I would
like to manipulate certain fields before they are imported.

TIA

if you want to manipulate the data, you'll either have to (1) do it in
code after it's parsed; or (2) run update queries against tblNewVendors
in your code.

Maybe I'm just ignorant, but the only way I have ever been able to
manipulate certain fields before they're imported is to read the lines
of text in code, parse them by using Split() or something like it, and
then doing my manipulations and finally appending by using a recordset.
PITA. Easier to dump to a temp table, manipulate the raw data and
then dump the massaged data to final table from there using an append
query.