Scientific notation
 

I have a rather extensive excel spreadsheet and when I save it into CSV
format and try and import it into a SQL database I cannot due to the number
been in scietific notation. I have foramted the numbers inot number format.
What am I doing wrong?

Clive wrote:
I have a rather extensive excel spreadsheet and when I save it into
CSV
format and try and import it into a SQL database I cannot due to the
number
been in scietific notation. I have foramted the numbers inot number
format.
What am I doing wrong?

Please post some sample data.

Jamie.

--

If you open that .csv file in Notepad, are those numbers really in scientific
notation?

If no, then it sounds like it's not excel's problem.

If yes, maybe you could create that .csv file with a little more control.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Clive wrote:

I have a rather extensive excel spreadsheet and when I save it into CSV
format and try and import it into a SQL database I cannot due to the number
been in scietific notation. I have foramted the numbers inot number format.
What am I doing wrong?

--

Dave Peterson