Data Import leaves blanks

[Jeff Giroux]

I have a excel file, for example, that looks like the chart below.
4000
4001
4002
4003
4003a
4004


I'll save this file, open a new file, and then on the new sheet try to
import this data. I'll go through the steps of selecting the worksheet and
so on, but then when it imports it looks like below.
4000
4001
4002
4003

4004


Why is that? It doesn't matter how I have my cells setup (General, Number,
Date, etc). This happens to any imports I try to do with the following
circumstances.
1. All the items in a column A (for example) have all contained nothing else
but numbers (or nothing else but letters)
2. Some of the cells in column A are a mix of numbers and letters (4005a for
example).

This also happens the other way around too. Say I start my sheet like
below.
4000a
4000b
4000c
4001
4001a
4001b


When I go to a new sheet and do the data import, I get the results below.
4000a
4000b
4000c

4001a
4001b


Why? I can't figure it out. Please, any suggestions would be great.

-Jeff

 

[Arvi Laanemets]

Hi

ODBC can't cope with mixed-type data, so it has to decide which type of data
is in column. Obviously it decided, that your data are numeric, so all
non-numeric entries are ignored.

 

[Jeff Giroux]

What's the work around...if any?

Hi

ODBC can't cope with mixed-type data, so it has to decide which type of data
is in column. Obviously it decided, that your data are numeric, so all
non-numeric entries are ignored.

 

[Arvi Laanemets]

Hi

Ad hoc 2 ways:

1. Convert all data in column to Text (simply set column format to text)
2. Use linking instead of ODBC