I have the following SQL statement to pull in data from a database.
INVMASTER.StockCode and INVMASTER.ShelfLife are both strings. How do I
change each field from a string to a number in the SQL code, so that it
comes into the spreadsheet as a number instead of a string?

SELECT INVMASTER.StockCode, INVMASTER.ShelfLife
FROM dbo.INVMASTER INVMASTER