Link to home
Start Free TrialLog in
Avatar of zachvaldez
zachvaldezFlag for United States of America

asked on

data format for Sql server

when exporting my excel file to SQL server using Import/export tool I have product number column which displays as 7.0865E+11 formatted as general. I reformat it to number with 0 decimal places in Excel to display as  708650000000. when I export it it gets to sql server as null
Avatar of arnold
arnold
Flag of United States of America image

How is the data brought in?
If importing, make sure to mark the column as a mdy.

In export, you have properly identify the column into which it is going.
Avatar of zachvaldez

ASKER

It turns to Null
what's mdy?
Month day year.
I think when importing, you have make sure the column into which it is going is a datetime .......
If your are going through an import wizard, the characterization of data with the correct data type.

It's a UPC code that should display as 708650000000 and not

 7.0865E+11 and I don't why it displays that way when opening a csv file in Excel.


ChNge the column display option, change it to text versus a number

If I change to text, it stays the same. format number change correctly

Product number would commonly be a text versus a numeric which the display is correct ....

How is the SQL defines the column whereas info?

I used text to columns and seems to be working

ASKER CERTIFIED SOLUTION
Avatar of zachvaldez
zachvaldez
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial