1
Answer

Extracting data from SQL 2005 to Excel: numbers issue

Dario Barbon

Dario Barbon
8y
308
1
Hi all!
In my production VB6 application, I use the following query to extract data to Excel.
  1. INSERT INTO OPENROWSET  
  2. ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database= E:\myfile.xls;', 'SELECT * FROM [Sheet1$]')  
  3. SELECT * FROM myTable  
This query works fine but in my Excel file all numbers are presented as text values  despite all columns type are correctly defined
Why? Is it a driver issue?
 
The server is SQL 2005 SP4 Workgroup Edition.
Thanks.
 
 
 
 
Answers (1)
Next Recommended Forum