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

« UserForm - Setting focus to a CommandButton based on a Cell's contents | Varaibles as both integer and String »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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