Data Type conversion error

[Nishikawa]

Hi,

I have a problem and wonder if anyone experienced this before.

I created column A and the data type is set to TEXT. The information to be imported comes from excel spreadsheet. The information that goes into the column has both text or number.

The problem happens if my first entry that goes into column A is a number, subsequent entires that are plain text are rejected even though the data type is set to TEXT.

Is there anything I can do to overcome this problem?

 

[namliam]

Yes this is a basic idea of Access thinking... which is a problem sometimes.
It indeed happens when in excel the first few rows (not sure how many) are numbers...

This is one of the reasons that excel is a substandard communication means between systems/users. It causes problems and is less controlable than i.e. textfiles.

To solve your problem, in excel set the column to "text" format. That helps most of the times, if that fails export the file from excel to CSV. Then import the CSV which gives you more control than importing a XLS file.

Good luck