troubleshooting Question

Can't Import .CSV file into Access

Avatar of Michael Paravicini
Michael ParaviciniFlag for Chile asked on
Microsoft Access
5 Comments1 Solution76 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
John Tsioumpris
IT Supervisor
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros