Importing csv file all data is in first column

S

SteinS, Oslo

When opening a csv-file (defined as a Excel comma separated file), all data
is placed in A1 and not in each column.
File has semicolon as delimeter and have defined semicolon (;) as List
seprarator in Regional Options. Trying this on other computers it's working
perfect. Does anyone help me with this one?

I could, of course, change file type csv to be opened as a text file and use
Text Import Wizard, but this will be a temporarily workaround.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Save As csv Carraige Return issue 3
Data Import Question 0
Excel VBA macro to auto import new CSV file from fixed directory 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Forcing Excel to Import .CSV data 2
csv files 1

Top