Import from Excel - not all values import

  • Thread starter Thread starter comish4lif
  • Start date Start date
C

comish4lif

Here's what I am doing:

I have a bunch of stuff in Excel, that I am importing into Access.

I started by just copying and pasting the table, which gave me the
table structure field names and types, etc. This process kicked out
some errors. Too many to correct via fat finger entry. So, I changed
the data type of one field from number to text. I deleted all the
records from my table. When I try to do the import, I still get "data
type mismatch" errors.

It's mostly a column of numbers, but there are some cell populated by a
text string like "This data not available" and "7,2" - both of these
get kicked out.

How do I get Access to just accept my values?
 
When ACCESS/Jet looks at your spreadsheet prior to importing, it "guesses"
at the data type for each EXCEL column by looking at the first 8 to 25 rows
of data (depending upon the setting in your Registry). If Jet doesn't find a
text string in those columns and finds numbers only, it will assign
"numeric" to the column/field, and then a subsequent text string will cause
the error.

Try making the frst row in the EXCEL spreadsheet be one that contains a text
string, and see if that helps.
 
Back
Top