importing text and numbers from excel

  • Thread starter Thread starter Guldo K
  • Start date Start date
G

Guldo K

Hello.
I have a problem importing data from excel.
I used to import a table from excel; this table had numbers (long) in
the first column, and text in the second. Fine.

Now, text shows up in the first column in excel, too. So the first
excel column now contains both numbers and text. I've changed the
field type in access from 'number' into 'text', and tried to import
using the insert query I've always used.

Unfortunately, text from the first excel column is not imported; I get
null instead. (or maybe zero length strings? I don't know)
Numbers from the first excel column, instead, are correctly imported
as text.

How can I fix it?

Thank you.
 
When importing an Excel file the first few rows determine
the formatting. Make sure you have alphanumeric data in
these rows, preferably the first row. I sometime add a
dummy record as the first record in excel with the correct
formatting.

Jim
 
If I have a "mixed" Column in Excel, I always create a "Calculated" Column
using the Spreadsheet function Text() to convert both numeric values and
text values from the original Column to Text values.

When I import the modified Excel spreadsheet, I skip the original Column and
import the "Calculated" Column.
 
Guldo K said:
I have a problem importing data from excel.
I used to import a table from excel; this table had numbers (long) in
the first column, and text in the second. Fine.

Now, text shows up in the first column in excel, too. So the first
excel column now contains both numbers and text. I've changed the
field type in access from 'number' into 'text', and tried to import
using the insert query I've always used.

Unfortunately, text from the first excel column is not imported; I get
null instead. (or maybe zero length strings? I don't know)
Numbers from the first excel column, instead, are correctly imported
as text.
Click to expand...

See:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
Back
Top