I have a vba script that pulls in an excel file:
This spreadsheet has a column of numbers, but they are joining a text field in the database (because rarely there are 1 or 2 fields that are text). This is importing as numbers and I get a type mismatch in join.
I either want a way to import the field as a number or change the field type to a number after it is imported, using SQL or VBA without altering the excel spreadsheet.
Much thanks!
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, tab_Union & "Extra", "C:\Local\union\in\" & tab_Union & "_Extra", True
This spreadsheet has a column of numbers, but they are joining a text field in the database (because rarely there are 1 or 2 fields that are text). This is importing as numbers and I get a type mismatch in join.
I either want a way to import the field as a number or change the field type to a number after it is imported, using SQL or VBA without altering the excel spreadsheet.
Much thanks!