Hi there,

Thanks for you reply, however I'm pretty sure the ACE drivers are only 32 bit and won't load into a 64 bit installation of SQL. To access say a CSV file or an excel spreadsheet using OPENROWSET I use the Microsoft.ACE.OLEDB.12.0 driver and this will anly load into a 32 bit installation. So I'm setting up a 32 bit instance to do all the extranal data reading and a linked server from my 64bit to the 32bit to make this available to my application. I don't use SSIS as data importing and scheduling etc. is handled by my app. Having said all that I'm more than happy to be proven wrong as I for one, can;t believe Microsoft have not released a 64 bit version of ACE.