G
geert.van.ransbeeck
Hello
The code below imports a csv-file into a table.
For the field F18 I don't get what I want.
In the csv-file 'F18' is of a 'general' format. I don'g get the data
correctly, it has been transformed into a 'time format'. Even if I add
the ALTER TABLE ALTER COLUMN statement to change the data into numbers
doesn't help. Now I have some blancs where there even shouldn't be
one.
Can somebody help?
DoCmd.DeleteObject acTable, "TBL_Import_TPXP_Radi_College_Newcsvfile"
DoCmd.TransferText acImportDelim, ,
"TBL_Import_TPXP_Radi_College_Newcsvfile", "X:\TRANSIT60\AFTP
\USPB1815\RADICOL\NEW.CSV", False, ""
DoCmd.RunSQL "ALTER TABLE [TBL_Import_TPXP_Radi_College_Newcsvfile]
ALTER COLUMN [F18] number"
The code below imports a csv-file into a table.
For the field F18 I don't get what I want.
In the csv-file 'F18' is of a 'general' format. I don'g get the data
correctly, it has been transformed into a 'time format'. Even if I add
the ALTER TABLE ALTER COLUMN statement to change the data into numbers
doesn't help. Now I have some blancs where there even shouldn't be
one.
Can somebody help?
DoCmd.DeleteObject acTable, "TBL_Import_TPXP_Radi_College_Newcsvfile"
DoCmd.TransferText acImportDelim, ,
"TBL_Import_TPXP_Radi_College_Newcsvfile", "X:\TRANSIT60\AFTP
\USPB1815\RADICOL\NEW.CSV", False, ""
DoCmd.RunSQL "ALTER TABLE [TBL_Import_TPXP_Radi_College_Newcsvfile]
ALTER COLUMN [F18] number"