I've posted a similar query to "Access: Other topics", but maybe this question would be more appropriate here"
I've searched through the previous CSV-related questions on Tek-tips, but couldn't find anything appropriate. Here is my problem, it's not an easy one:
1) I have a huge CSV text file, which I would like to import into MS Access.
2) Some of the text entries have commas and quotes inside. Here is an example how it looks, so you see my point:
3) I use the wizard (File | Get External Data | Import...) and during the wizard steps it looks like it breaks the fields correctly (you can scroll and see the temporary list in one of the stages of the wizard).
4) But when I click finish I get an error message:
"Text file specification field separator matches decimal separator or text delimiter."
and the data is not imported at all.
P.S. There is data in several languages, and the CSV is a Unicode text file. Could that also affect the wizard? I've played around with the values (Unicode, Cyrillic, Western), but this doesn't seem to have any effect.
This is quite urgent and I would be very thankful for your help!! ---
---
I've searched through the previous CSV-related questions on Tek-tips, but couldn't find anything appropriate. Here is my problem, it's not an easy one:
1) I have a huge CSV text file, which I would like to import into MS Access.
2) Some of the text entries have commas and quotes inside. Here is an example how it looks, so you see my point:
Code:
10:01, 01.01.2002, "here is comma, inside and ""quotes"" as well", "another, text field",
11:02, 02.03.2002, "and the word ""foobar"" means nothing, does it", "and test2",
3) I use the wizard (File | Get External Data | Import...) and during the wizard steps it looks like it breaks the fields correctly (you can scroll and see the temporary list in one of the stages of the wizard).
4) But when I click finish I get an error message:
"Text file specification field separator matches decimal separator or text delimiter."
and the data is not imported at all.
P.S. There is data in several languages, and the CSV is a Unicode text file. Could that also affect the wizard? I've played around with the values (Unicode, Cyrillic, Western), but this doesn't seem to have any effect.
This is quite urgent and I would be very thankful for your help!! ---
---