Importing

[s4bill]

I am importing from a spreadsheet. The column is formated as text.
In the design view of the Access table for the associated field it is showing text.

When it encounters a record that is all numbers and no letters it imports it as an exponent

i.e. 32986698 is imported as 3.29867e+007

What can I do to correct this?

Thanks
Bill

 

[dcobau]

I think the column is not wide enough to display the value. Widen it by dragging its right edge to the right with your mouse.

Dave