"Type Conversion Failure" errors

P

Paddy

Hi all,
Am importing multiple excel files to access and
all seems to work fine except i get alot of error
messages while importing due to "Type Conversion Failure".
All my Data types and field names in both applications
are identical except some of the input values are empty
and it varies from file to file with each having
different values in their feilds. Any help on how to get
rid of the error messages will be much appreacited.

P.S am a novice with access
 
R

Roger Carlson

Importing from Excel is tricky. When you import a sheet into a table,
Access decides on the datatype based on the first few rows in the sheet.
So if you have a number in the first cell of a column, it will create a
numeric field to hold the column. If in subsequent rows, the value has a
character value, you will get a Type Conversion error.

I am personally much more comfortable with importing text files and so I'd
recommend saving the sheet as a comma delimited file (CSV) and import that.
You have much more flexiblity with text files.
 

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

Similar Threads

Getting rid off errors messages while importing from excel 0
Why am I getting Type conversion failure when using transfer text 1
How do i fix a type conversion failure? 4
Type Conversion Failure importing number as text 1
type conversion failure error 1
How do I correct "Type conversion Failure" in Access 2007 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
Import CSV Type Conversion Failure 3

Top