Software

Ask something
Discussion Locked

Type conversion error - Access

0 helpful
3 replies

by nsohenick

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I am importing an excel spreadsheet into access 2000. I get an type conversion error. I have the field listed as text. It should bring everything in right? It brings in everything without spaces or letters. But when it gets to fields that contact letters and spaces and dashed and sometimes "/" it doesn't want to. How can I get it to import whatever is in that field???

Thanks much

Nicole Sohenick

3 replies

by chainsawz

I've run into this problem a few times, and I just use a quick work around. I save the excel file as a tab delimited text file, and then import into access. This seems to resolve any import errors.

I hope this helps!

This discussion is closed to new replies.