Avatar of Michael Paravicini
Michael Paravicini
Flag 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
Microsoft Access

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
John Tsioumpris

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
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Michael Paravicini

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
Michael Paravicini

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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
John Tsioumpris

Glad I helped you