I use the SQL script
Insert into OPENROWSET (' MICROSOFT. JET. The OLEDB. 4.0 '
, 'Excel 5.0; HDR=NO. The DATABASE=C: \ A.x ls' sheet1 $)
The select cost amount from billing details
Export to EXCEL
Cost value of the column left upper corner of the cell has a small green triangle, hint: the number in the cell to text format
I the amount of data is a bit big, don't want to go to each EXCEL to modify this column
Is there any good SQL script method, derived after the float type data export EXCEL shows the numeric data (no small green triangle)
CodePudding user response:
The selected columns, in Excel format cells into numerical values