You start out by saying "we .import an excel file into our database..." then you say "...after import...excel treats the Code as exponential values"? are you import into FMP? or exporting to excel?
Do a Save as... tab separated text on the Excel file then import the tab-separated file. I had the same problem with an Excel import and mixed alpha - numeric fields - all "e"s become signs for exponentiation.
You will need to update your scripts for the tab-separated import.
We get an excel spreadsheet once a month that we import into FMP.
I'll give it a try. Thanks