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?
|