I am trying to import a csv file using Ms Query because I want to process the data with SQL before the import.
When I am at the mask "Define Text Format" I am getting an error "Text file specification field separator matches decimal separator or text delimiter. Guess failed". This happens because I have a comma as a decimal separator. I tried to google for a solution but didn't really find one (except changing regional setting with VBA which I am not too keen to do). Shouldn't it be an easy task to import csv files? They are pretty common and many countries have comma as a decimal separator...
Any ideas?? Thanks!
Jack
When I am at the mask "Define Text Format" I am getting an error "Text file specification field separator matches decimal separator or text delimiter. Guess failed". This happens because I have a comma as a decimal separator. I tried to google for a solution but didn't really find one (except changing regional setting with VBA which I am not too keen to do). Shouldn't it be an easy task to import csv files? They are pretty common and many countries have comma as a decimal separator...
Any ideas?? Thanks!
Jack