Importing CSV

  • Thread starter Thread starter IgorM
  • Start date Start date
I

IgorM

Hi

I get an error when trying to import csv file with the following structure:

"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup
us³ug-Warsztat","594,00","Ogó³em US£UGI WEWNÊTRZNE NAPRAWCZE :","594,00"

"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","405","
403510","Us³.obce-prz.okr.bad.tech","80,33","Ogó³em US£UGI TRANSPORTOWE,
REMONTOWE, UTYLIZ. :","80,33"

The message says that the separator of specification field of text file is
the same as decimal separator or text delimiter (I tried to translate it,
hope it is understandable).

Kind regards

Igor
 
IgorM said:
Hi

I get an error when trying to import csv file with the following structure:

"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","304"," 490020","Zakup
us³ug-Warsztat","594,00","Ogó³em US£UGI WEWNÊTRZNE NAPRAWCZE :","594,00"

"Data:2008-10-17 13:15","Agregacje wg no¶nika kosztów","Kryteria: Okres
pomiêdzy 1 i 9; Rok finansowy: 2008","No¶nik kosztów","Agregacja","Konto
ksiêgowe","Kwota","No¶nik kosztów: B100","405","
403510","Us³.obce-prz.okr.bad.tech","80,33","Ogó³em US£UGI TRANSPORTOWE,
REMONTOWE, UTYLIZ. :","80,33"

The message says that the separator of specification field of text file is
the same as decimal separator or text delimiter (I tried to translate it,
hope it is understandable).

Kind regards

Igor
Click to expand...

Hi Igor,

When Access imports text data, it looks for specific characters to
separate fields, and to indicate a text string. You specify these
characters, either in the "import wizard" or by creating a
"specification" which can be saved and re-used. You need to specify
different characters for different purposes. It sounds to me that you
have used one of these characters (could be tab, comma, space, quote, or
others) in more than one role. This would explain the error message.
If you experiment with different combinations, you should normally be
able to get it to work.

Good luck!

Phil, London
 
Your regional settings have the comma as the decimal separator, so you can't
use a comma as a field delimiter. Most European locales use the semi-colon to
delimit fields.
Before importing, process your csv to replace "," with ";" (Include the
quotes in both find and replace strings!)
Pozdrawiam
 
Back
Top