importing a csv to access 2007 using vba

[izharmel]

Hi,
I import a csv file to an access table using the following code as a part of a larger code:

DoCmd.TransferText acImportDelim, , strTableName, strPath & objFile.Name, True

Prior to the import, I imported the table manually, so that I have a base table to import to.
Every time I import, I delete the data from the access table and import the new one onto it.
It works fine except for the fact that one of the columns has values of '0' most of the time and sometimes changes to '0.1'.
For some reason the column is always imported as '0'.
I tried to define the column as Double, Decimal, or even text, and nothing works...
Any ideas anyone?

Thanks in advance,
Izhar