Hello to all experts out there,
I am seriously stuck due to the beauty of Microsoft Access....
I encountered a problem creating tables with sql and then importing data from csv files using TransferText. Everything works fine except for one field, which I defined as text (in the sql create statement) but in which the csv files contain all kinds of alphanumeric strings. The entries which are not purely numeric are simply not imported (the fileds remain empty). I also tried to define that specific field as char and varchar in the sql statement, but the problem was not solved. Does anybody have an idea??
Part of my code is as follows:
Tablename = "Lim" ' varying table names
sqlCreate = "CREATE TABLE " & Tablename & "today" & "(A Long,B Text,C Text,D Text);"
DoCmd.RunSQL sqlCreate
DoCmd.TransferText acImportDelim, , _
Tablename & "today", CSVFileName, True
where my csv file looks something like this:
A; B; C; D;;
1000009; Kat; C1; mcs;;
1000009; Fld; K500;mcs;
1000009; KuGru; 8; mcs;
Problem does not occur while importing other csv files or in other fields of the current csv , besides column C. Though defined as text, only the numeric expressions are imported. So my table looks the almost the same, only that in column C, I get empty entries instead of "C1" and K500" and only the numeric expressions like "8" are imported properly. I am new to VB and SQL so I would appreciate simple suggestions.
Thanks in advance
I am seriously stuck due to the beauty of Microsoft Access....
I encountered a problem creating tables with sql and then importing data from csv files using TransferText. Everything works fine except for one field, which I defined as text (in the sql create statement) but in which the csv files contain all kinds of alphanumeric strings. The entries which are not purely numeric are simply not imported (the fileds remain empty). I also tried to define that specific field as char and varchar in the sql statement, but the problem was not solved. Does anybody have an idea??
Part of my code is as follows:
Tablename = "Lim" ' varying table names
sqlCreate = "CREATE TABLE " & Tablename & "today" & "(A Long,B Text,C Text,D Text);"
DoCmd.RunSQL sqlCreate
DoCmd.TransferText acImportDelim, , _
Tablename & "today", CSVFileName, True
where my csv file looks something like this:
A; B; C; D;;
1000009; Kat; C1; mcs;;
1000009; Fld; K500;mcs;
1000009; KuGru; 8; mcs;
Problem does not occur while importing other csv files or in other fields of the current csv , besides column C. Though defined as text, only the numeric expressions are imported. So my table looks the almost the same, only that in column C, I get empty entries instead of "C1" and K500" and only the numeric expressions like "8" are imported properly. I am new to VB and SQL so I would appreciate simple suggestions.
Thanks in advance