Search results

Thanks for the help. I actually found that rather than adding a dummy row into the spreadsheet, I could add an alpha to the end of every value in the column and then remove it with an update statement once it was in the table. This preserved the correct formatting and I didn't have to export it...

Yes. Both the spreadsheet and Access field are formatted as Text.

I am having a problem importing an Excel spreadsheet into Access. I have an existing table with all fields as Text. One of the columns in the spreadsheet is mostly numeric, but occassionaly has an alpha character. Access was returning a Type Conversion Failure any time there was an alpha in that...