I am importing a large group of Excel files that includes two columns of numbers that are formatted as text. I import them, as is, into a temp table and now am trying to append them to the final table while changing the data type from text to numeric. The problem I am having is that when I change the data type the numbers are being truncated to integers.
I have tried Value, CInt, CDbl, CSng and also tried changing the final table format to General Number, Single, Double, Fixed Format, Standard Format, General Number Format with Decimal set to a specific number and to Auto. Every time the number loses anything to the right of the decimal point.