View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oceanmist oceanmist is offline
external usenet poster
 
Posts: 49
Default exporting from sql query results to a excel workbook

Hi,

I have managed to get an
example:(http://support.microsoft.com/kb/307029/en-us) working that exports
from an example mdb file called northwind but In my project I have an sql
database and I have tried to change the connectionstring to the mdf database
but I recieve this error
"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done." what do I need to change to get
export working from my own database.