hello
I am using below code to do csv import
DoCmd.TransferText acImportDelim, tableName:="tbl_Basic", _
FileName:="C:\Download" & "CS" & getMonth & "" & CStr(getYear) & "\PILOT_BASIC.csv", HasFieldNames:=True
itdoes works well but also adds one extra column in table tbl_Basic at the end called NoName, while there is such column in CSV file.
Please advise.
I am using below code to do csv import
DoCmd.TransferText acImportDelim, tableName:="tbl_Basic", _
FileName:="C:\Download" & "CS" & getMonth & "" & CStr(getYear) & "\PILOT_BASIC.csv", HasFieldNames:=True
itdoes works well but also adds one extra column in table tbl_Basic at the end called NoName, while there is such column in CSV file.
Please advise.