Import Excel Data

  • Thread starter Thread starter Dthmtlgod
  • Start date Start date
D

Dthmtlgod

I am trying to do a simple import of External Data.

An Excel spreadsheet with 10 columns, all fields are straight text fields.
I am importing data into an existing table.

It imports the first 913 rows no problem, but then rest of the row, it
failed to import one of the columns. I get a
"Type Conversion Failure" errors on the column named "TYPE". It works on
rows 1-913, but not the rest.
The data in rows 1-913 contains the word "81" and rows 914-1242 contains the
word "DRT".

What could cause this?

Thanks in advance
 
suggest you try highlighting the entire column, in Excel, and manually
setting the format to Text. then try the import.
if that doesn't work, next suggestion is you save the Excel file as .txt and
import that. you'll have full control of the field's data type on import,
with a text file.

hth
 
Hi,

Check the data types in the existing Access table. If all the fields are
of type Text, the import should work.

If however the TYPE field in the existing table is a number field the
import will fail in the way you describe.
 
Trying changing the value of the following registry key to zero:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows
 
Back
Top