Exporting error

[Carolyn]

When creating a new database and exporting exel sheet into access I got error
sheet:

Sheet1$_ImportErrors

Error Field Row
Type conversion Serial# 24

17 rows and random Row numbers.

Clearly I am new.

Please advise.

 

[John Spencer]

One possibility: The Serial# in the rows cannot be interpreted as a number
value and that is what the export routine decided the field type would be.

Try opening the table in design view and if the field is numeric, change it to
text. Now, DELETE all the records and import the Excel data into the table.

Otherwise take a look at the rows that did not import and see if you can
determine the differences between the rows that did import and the rows that
did not. Some things to look for: letters in the Serial# versus no letters in
the Serial# or dashes versus no dashes or spaces versus no spaces or if all
numbers in the fields the size of the number.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Ken Snell]

Just a wild guess, based on your very limited information, is that the
Serial# column in EXCEL is marked as Text type, but it contains number-like
values (all numeric digits) that, when read as numeric values, are too large
to fit into a Long Integer field in ACCESS.

See thisarticle for more information:
Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or
when Linking to an EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#DataTypeErr

 

[Carolyn]

John and Ken:

I think you are both correct.

Before exporting into Access a few of the boxes had like 2.91+10E etc. etc.
and I know that it was sapposed to be some value but I could not determine
what it was so I simply cleared thoses boxes but it must have remember the
error behind the secnes so to speak on the excel sheet.

I will also check in design view as you have outlined.

Now how are you at clalendering issues