I import a csv file to an access table using the following code as a part of a larger code:
Expand|Select|Wrap|Line Numbers
- DoCmd.TransferText acImportDelim, , strTableName, strPath & objFile.Name, True
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