importing data

  • Thread starter Thread starter elwyn
  • Start date Start date
E

elwyn

Hi again all

I have exported data from a non-excel program and have saved it as a comma
seperated file but when I try to import it into excel the list just uses the
A column with the headings seperated as a comma. I have 8 headings and would
like to each heading to have it's own column when I import it. I am trying
to use Data/Import External Data/Import Data but I cannot for the life of me
figure out how to do this.

MTIA

Elwyn
 
Use data>text to columns>delimited>comma and look at the format below to see
if it is correct>next.
It's pretty "self explanatory"
 
Does your windows Regional setting for your list separator match the character
that's used in the .csv file?

Windows start button|Settings|control panel|regional settings|number Tab

Is how I'd check in win98.

Maybe the other program uses a comma and excel (through that windows setting) is
expecting a semicolon.
 

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

Formatting with imported data 2
Import External Data 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import XML data...Is there a size limit on the import? 0
comma delimited not seperating into columns 1
Unwanted formatting with imported data 1
skip columns when importing from text 1
Is it possible to count specific words in a number of cells? 1

Back
Top