I am trying to create a procedure to import price files from Excel into an access database.

However, the stock codes contain alpha, and numeric characters.

Also, if the first stock code is a raw number, Access will ONLY import stock codes that are numbers (anything with text is dropped).

If the first stock code has letters, then it will import the stock codes with letters but automatically converts all numbers over 10000000000 into scientific notation.

The receiving table is set up with that column as text.

Any help?