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

Show your code.

Tim


"OceanMist" wrote in message
...
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.