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.