What to do with import errors from excel to access 2003

[TFP]

Hi all!

I have some issues when importing my data from excel to access. I'm trying
to create a file that contains all of my excel fields. In the excel there is
some fields that are both text and numbers (e.g. PR11, 1T and so on). The
database creates the logfile of import errors and what i can read from that
is that it continuesly complains about fields that are containing both text
and numbers. I can't manage without that informaiton. If excel only could
handle more rows it would not be a problem. I have tried to format in all
ways possible but nothing seems to help.

I have also tried to convert excel into .CSV file format and that helped out
a bit. Managed to create an almost good file, but are missing out some text
information, but best so far. The rows are ower 1,5 million rows, and the
fault percentage is to high at the moment.

Have looked in the forums and @ online help and tried to create in all
possible ways (if you ask me, but obviously not the right one *lol*)

 

[Ken Snell \(MVP\)]

See this article:

Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or
when Linking to an EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#DataTypeErr