ADO.Net 2.0 version of CopyFromRecordset

B

BillyRogers

Here is a line of code I used in an Access application using ADO to call a
stored procedure and then open excel and past the recordset to excel.

xlApp.Workbooks(1).Worksheets(1).Cells(2, 1).CopyFromRecordset rst1

Is there a version of CopyFromRecrodset that I can use in VBExpress with
ADO.Net 2.0 to past a DataTable into Excel?

Thanks,


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO to pull data from Access query 3
ado copyfromrecordset and nextrecordset 4
Get a total when number or rows is not know in advance 0
Sum a Spreadsheet Column from Access 1
Windows API 4
Aqua buttons 8
CopyFromRecordset Question 3
find combination of cells that equals a sum 7

Top