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
Microsoft SQL Server
Last Comment
zachvaldez
ASKER
It turns to Null
ASKER
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.
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.
ASKER
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
ASKER
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?
How is the SQL defines the column whereas info?
ASKER
I used text to columns and seems to be working
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If importing, make sure to mark the column as a mdy.
In export, you have properly identify the column into which it is going.