CODEWITHSUNDEEP
excelms-access
MrLockett
MrLockett

Reputation: 115

Excel Live linked files imported into Access as Short Text Data Type Instead of Number Data Type

I am importing sheets from the same workbook in excel into Access. The data that I'm importing is set as a number for all sheets. Most sheets import as a Number Data Type for the imported field, but some are importing as a Short Text Data Type no matter if its set as a number field. I need to know what I can do to fix this since I cannot change the data type in access for the Imported Live Linked Excel Sheet.

Thank you,

Upvotes: 0

Views: 116

Answers (1)

Gustav
Gustav

Reputation: 55906

Don't import the sheet, but link it. Then create a simpel select query with the linked table as source and where you convert and clean up the data.

Now, use this query for importing to the final table or your further processing.

Upvotes: 1

Related Questions