TransferText problem

[rossib]

I would be grateful for some help.



I have a csv file (C:\cc.csv) as follows:

PurchaseOrderNumber,DocumentDate
6310S02621733,12/12/2009
6310S02621734,12/12/2009

I have created a table in Access2003 with the correct field names. The data type for both fields is "Text". (DocumentDate is text format as I need to manipulate it after import) I am trying to use VB code to import the data from the csv file to the table using code:

DoCmd.TransferText acImportDelim, , "ORDERS", "C:\cc.csv", True

It reads the data in but omits the letter "S" (fifth character in first field)

If the "S" is relaced with a "V" or "X" and I run the code, the "V" or "X" are imported correctly.

This must be caused by something incredibly simple, but unfortunately I cannot find it!!

Thanks in anticipation.

[RuralGuy]

To be honest, that does not look like a properly prepaired .csv file. The first field is obviously a string (text) field and yet not surrounded with double quotes.