Importing CSV file with Get External tab when comma as decimal separator

jack10063

Board Regular
Joined
Aug 12, 2008
Messages
103
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,122,842
Messages
5,598,396
Members
414,235
Latest member
sucosama

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top