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',
'SELECT * FROM [tri_svc$]')