PC Review


Reply
Thread Tools Rate Thread

ADO.Net 2.0 version of CopyFromRecordset

 
 
=?Utf-8?B?QmlsbHlSb2dlcnM=?=
Guest
Posts: n/a
 
      31st Jan 2007
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CopyFromRecordset acrawford@newbreed.com Microsoft Access 1 6th Aug 2006 04:26 AM
SQL CopyFromRecordset =?Utf-8?B?QnJldA==?= Microsoft Excel Programming 2 23rd Jul 2006 06:56 AM
CopyfromRecordset MattShoreson Microsoft Excel Programming 2 15th Mar 2006 01:36 PM
CopyFromRecordset does nothing E Harris Microsoft Excel Programming 5 8th Jan 2004 04:29 PM
CopyFromRecordset Microsoft Excel Misc 0 18th Dec 2003 08:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:29 AM.