Microsoft really needs a feature to turn off Scientific Notation. It's
causes us no end of aggravation and we give them a ton of businsess.

I'm importing a spreadsheet into Access 2003 from Excel 2003. There are
account numbers such as 0123456789 or 0123E456987 that undesirably convert to
scientific notation upon import. Users enter these values in Excel, so the
column is formatted as text (if it were General, the lead 0 would drop out.)
I then, using automation from Access running Excel macros, append an "x" to
the front of the cell values and convert the format to General, then use
TransferSpreadsheet to bring into Access. That's a hassel.

Is there an algorithm I can us in Access to convert scientific notation back
to text or will the fact some accounts start with a 0 create a problem?
We've had this issue for over a year withou satisfactory resolution.