I am having trouble when I import an Excel spreadsheet into Access. The error is "Type conversion Failure".
The thread on this was started here:
https://www.accessforums.net/showthread.php?t=69439
I know that Access ignores the first row of the spreadsheet If you tell it to) and read the values in the second row of cells to determine what type of data
is in the column. Once it selects a data type and if sees an inconsistency (another data type) then it registers a:
Type Conversion Failure
The spreadsheet that I am working is in that situation now. I know that one trick is to convert all the data in Excel into text and then import to Access and then change the actual numerical data (which is now text) back to numbers.
That seems logical.I am looking for a way to program this. I have found a way to convert all cell values (either text or numeric) to text.
That is the first step.
I already have a program to import the Excel spreadsheet.
That is the second step.
I am just confused about third step.
Once all of this has been imported into Access and is in a table as text, how do i go through and change what was initially numeric data
and was converted to text data back to numeric data.
I can do it one at time, but that could get tedious.
There must be a way to program and automate this.
Any help appreciated. thanks in advance.
Respectfully,
Lou Reed