Importing csv into excel and not retrieving all data

B

Brian

Hi, When I import external data using the wizard I am not
getting all
of the data. Here is the problem. I am importing a csv
file into
excel using the wizard. Then when I look at my data the
alphanumeric
data I have is ignored. For example in the same column I
have 1234,
1234A, 1234B etc. But the 1234A and 1234B won't show up
after I
imported the data. Can anyone please help me to know how
to fix this.
Thanks for your time!
 
T

Tom Ogilvy

I suspect it is treating the column as numeric. Try putting in a dummy row
at the top of your .csv file that has alpha numeric data in all the columns
that need to be alpha numeric. I haven't seen this, so this is just a
guess, but it sounds like what might be happening.
 

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

Forcing Excel to Import .CSV data 2
Importing csv into excel and not retrieving all data 0
Adding data to MS Access from csv file 0
Excel VBA macro to auto import new CSV file from fixed directory 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
How to import csv file data to already open worksheet (in C#) 0
Creating a drop box or Dlook up 2

Top