Michael Paravicini
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Glad I helped you
or you use Access to read the .csv as text and import it line by line