Import from Excel - not all values import

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?
 
K

Ken Snell [MVP]

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.
 

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

Top