I'm importing a huge table from Excel, and all goes pretty smoothly except a Cost Center column. It contains the ten digit alpha numeric cost center. For some reason it converts a small number of the entries to scientific notation during the import.
Is there any way to prevent this?
Should I be asking on the Excel forum?
not sure how to get rid of excels problem, but I find that when importing excel files to sql it is generally less troublesome if you save the .xls file as a text file (.csv), then import the text file to sql.