View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Change the file extension to txt and import it with the text import wizard
and in step 3 select text under column data format
You can actually keep the CSV extension and open it via
dataimport text file and in the window that opens select all file types *.*
and it will also start the wizard


Regards,

Peo Sjoblom

"David B" wrote:

I am trying to put CC numbers in to a data base using a csv format but every
time I save it as .csv it puts my CC numbers into scientific notation. Any
ideas pn how to fix that?