Type Conversion Failure Error Message on Import (1 Viewer)

andy_dyer

Registered User.

Local time

Today, 16:48

Joined

Jul 2, 2003

Messages

806

• Feb 27, 2004

• #1

Help!

I have over 2000 records being imported, and I have 12 that just will not import for love nor money!!

I get the above error type for certain fields...

I have checked, cross checked and checked again and I cannot work out what could be the problem on these fields for these records!

Anyone got any further suggestions for things I can check for??

 

Mile-O

Back once again...

Local time

Today, 16:48

Joined

Dec 10, 2002

Messages

11,316

• Feb 27, 2004

• #2

Give an example of what the twelve are - what data type, and what format?

 

andy_dyer

Registered User.

Local time

Today, 16:48

Joined

Jul 2, 2003

Messages

806

• Feb 27, 2004

• #3

After much hair pulling...

It appears that for some reason Excel had taken to putting a " ' " in some blank fields so of course you couldn't see them in Excel but it was making access think that it was a text field and it was in fact a number field!!

No idea what was going on there!!

Access could really do with some better error messages!!

Thanks Mile for the offer!

 

Mile-O

Back once again...

Local time

Today, 16:48

Joined

Dec 10, 2002

Messages

11,316

• Feb 27, 2004

• #4

andy_dyer said:

Access could really do with some better error messages!

Click to expand...

And users!