Hello all...
Need some help. I am working on a project which requires import of a csv file which also creates the table. The file will not have standard headers or column locations. So far everything is working beautifully until I reach an instance where the first X number of rows of data does not contain decimal points but there is data in the column which does (make sense).
Code Used:
DoCmd.TransferText TransferType:=acImportDelim, tableName:="llp", _
FileName:=llpcsv.Value, HasFieldNames:=True
For Example:
CSV File = Column1,0,0,0,0,0,0,0...,1.25
The import is just importing 1 (not 1.25).
It would work fine to specify that the entire file should be formatted with 2 decimal point when imported, but I can't find how to do this.
Help please...