Good morning!

I am using SQL 2000 and I am using OPENROWSET to export data from a SQL table into existing excel spreadsheets. Currently, the data comes through as text and I would like it to come through as float. I read that you can create a format file in order to format the data for export. I was having trouble trying to incorporate the format file into my exisiting code and any direction would be helpful.


insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=D:\trending_tool\tri_template.xls;', 
'SELECT * FROM [tri_svc$]') 
select *
from ccmcp.afaulk.cap_levers_final