I am importing an Excel spreadsheet into Access. One of the columns, contains the following types of data:
Numeric - 12345
Alphanumeric - 123L
blank cells
Alpha - New PO Number
I have formatted the column as text in Excel and described the column in Access as text. Access imports the column that contains 123L and the column that contains New PO Number as blank. If I remove the L, I still get blank unless I format the column using the parsing method - data text to columns. However, I still cannot get the alpha data to import. I understand that formatting cells in Excel only means that you are formatting the way they look, you are not changing the actual data.
How to you handle all four situations in one column? The data is being imported from different applications and is being manipulated manually in Excel. We are working on the automation of this process, but need to solve this problem right now.
Numeric - 12345
Alphanumeric - 123L
blank cells
Alpha - New PO Number
I have formatted the column as text in Excel and described the column in Access as text. Access imports the column that contains 123L and the column that contains New PO Number as blank. If I remove the L, I still get blank unless I format the column using the parsing method - data text to columns. However, I still cannot get the alpha data to import. I understand that formatting cells in Excel only means that you are formatting the way they look, you are not changing the actual data.
How to you handle all four situations in one column? The data is being imported from different applications and is being manipulated manually in Excel. We are working on the automation of this process, but need to solve this problem right now.