Link to home
Start Free TrialLog in
Avatar of Michael Paravicini
Michael ParaviciniFlag for Chile

asked on

Can't Import .CSV file into Access

I am having trouble importing a .csv file into access. The .csv file looks as follows if opened in Excel:


15.02.20      Lohnzahlung                  -70,3      12.02.20
15.02.20      Lohnzahlung                  -74,95      12.02.20
16.02.20      Rechnung Bettio Glarner      -100      30.01.20
20.01.20      Belast. E-Banking      -995.90      20.01.20

The problem seems to be with the coma (as we are using European currency format). I have tried with
OpenText, TransferSpreadSheet and even tried to read line by line using Input As #1. Nothing seems to be working. Any help would really be appreciated. Thanks Michael
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Unless you format the .csv to match regional decimal format it won't get imported correctly (hint : Notepad++)
or you use Access to read the .csv as text and import it line by line
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Paravicini

ASKER

Thank you so much John. I simply forgot to use Line Input instead of just Input... Now it works perfectly. Again, thank you so much for your help. Best regards Michael
Thank you so much John. I tried exactly the same but forgot to use Line Input  instead of just Input.. Now it works perfectly. Thanks for your help. Best regards Michael
Glad I helped you