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
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
Last Comment
John Tsioumpris
ASKER CERTIFIED SOLUTION
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
or
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 questionASKER
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
ASKER
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
Glad I helped you
or you use Access to read the .csv as text and import it line by line