I'm still playing around with this and is still not working. It is something to do with the OLE driver. I've checked all the registry settings etc and everything looks...

Thank you Mohammed for your comments and the link I will read all what you have sent in a second, but I thought I would give you a little more...

I'm having issues also with exporting to excel but I've been using this :

CREATE Procedure [ExportToExcelSheet](@fileName varchar(255))

as

Declare @sql varchar(1000)

Set @sql ='

insert into OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',

''Excel 8.0;Database='+@fileName+';HDR=YES'',

''SELECT * FROM sheet1$'')

select *...