Hi Guys,

I'm trying to import a tab delimited text file to access table. But it keeps producing error saying that MS office access was unablt to append all the data to the table. However, if I were to change the file to a comma delimited instead, then access has no problem importing. :confused:

The reason I use tab delimited is that one of the field has data separated by commas, so using a comma delimited will kinda confused the reading of the text file.

Please help.

Thx a mill!!:D

If any of your table fields are anything other than text or memo you will get errors. Any of your table fields other than text?

These are the values (inside quotation marks) in the fields:

"131192" "12/26/2005 8:00:00 PM" "0" "15" "SubNet=ADM,SubNet=06,Context=Anc"

Will this be a problem?

Thx

You should still be able to use comma delimited even if there are commas in the data.
How are you creating the original file?

Peter