I have an Excel spreadsheet from an external source that causes errors when importing into an Access database.
The problem states that some of the columns have a type conversion Failure.
The problem is the columns that are being affected are identical to some of the other columns being imported ie,
1 column has numbers and text, but wont import the text, and the other column also has number and text yet imports them both.
The reason why I stated it was from an external source is because im not sure whether the person did some copy and pasting using 2 different file formats although appear identical on the Excel spreadsheet.
My question is, how can i convert the column that wont import properly to the same text format as the column that does import. I have tried just about everything, ie same allignment same font same size, same cell format etc, it seems as though the problem is hidden somewhere else.
Can anyone help
thx
The problem states that some of the columns have a type conversion Failure.
The problem is the columns that are being affected are identical to some of the other columns being imported ie,
1 column has numbers and text, but wont import the text, and the other column also has number and text yet imports them both.
The reason why I stated it was from an external source is because im not sure whether the person did some copy and pasting using 2 different file formats although appear identical on the Excel spreadsheet.
My question is, how can i convert the column that wont import properly to the same text format as the column that does import. I have tried just about everything, ie same allignment same font same size, same cell format etc, it seems as though the problem is hidden somewhere else.
Can anyone help
thx