PHONE# COMING OVER AS SCIENTIFIC NOTATION 1

[PrgrmsAll]

I have an Excel worksheet with maybe 30 fields in it. One of these fields in TaxID and another is Phone#. I am SIMPLY wanting to import it into an Access table (existing). I have done this in the past, without any issue. This time, however, I seem to continually be getting some of the TaxIDs and Phone#s coming over in scientific notation. I have tried most of the obvious things like ensuring they are set as text in Excel. I am not sure what the user did to the spreadsheet but I do know that the records with abnormal values are records that had their TaxID and Phone# value modified. Is there any way around this?

Thanks in advance.

 

[67peshawar294]

All,
Make sure the field in Access you are importing the values to is formatted as text also.
jim

 

[PrgrmsAll]

YEAH, i THINK THAT WAS PART OF THE PROBLEM. I EXPORTED THE EXCEL AS A CSV, REIMPORTED THAT TO ACCESS. ACCESS DID WANT TO CHANGE THE TAXID AND PHONE FIELDS TO LONG-INTS, I JUST SWITCHED THIS TO TEXT AND ALL APPEARS WELL.

UNTIL THE NEXT QUIRK.

THANKS FOR YOUR RESPONSE.