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
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
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.
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
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
or you use Access to read the .csv as text and import it line by line