Extracting data from SQL 2005 to Excel: numbers issue

Question

Hi all! In my production VB6 application, I use the following query to extract data to Excel. INSERT   INTO  OPENROWSET   ( 'Microsoft.Jet.OLEDB.4.0' ,  'Excel 8.0;Database= E:\myfile.xls;' ,  'SELECT * FROM [Sheet1$]' )   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.

ali tuncer · Answer

In excel file, add a row with number values and hide the row.. http://www.sqlservercentral.com/Forums/Topic255083-8-1.aspx