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
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.
If importing, make sure to mark the column as a mdy.
In export, you have properly identify the column into which it is going.
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial