How do I correct "Type conversion Failure" in Access 2007

B

BigK

Importing database from Excel 2007 and get "Type Conversion Failure" in a
couple columns containg numbers. Have tried changing the fields data type to
text, etc. No luck.
Help?
 
P

Piet Linden

Importing database from Excel 2007 and get "Type Conversion Failure" in a
couple columns containg numbers. Have tried changing the fields data typeto
text, etc. No luck.
Help?
Click to expand...

Try creating a table by linking to the Excel file and creating an
empty table. Then fix the columns that are not working, then run the
append.
 

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

Import CSV Type Conversion Failure 3
How do i fix a type conversion failure? 4
Type Conversion Failure importing number as text 1
Why am I getting Type conversion failure when using transfer text 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
type conversion failure error 1
Template with fields and premade texts.. 0
Type Conversion Failure 1

Top