Save Excel File Data to recordset

[Phoebe]

Hi, Good Day!

Currently I have a few excel file storing different range of data.
For eg. 1-100 in FileA; 101-200 in FileB; 201-300 in FileC...total 10 file.
I'd like to save these set of data to a recordset so that I can do some
update on this whole set of data.

Can someone help.
Thanks in advanced.

rgds,
Phoebe.

 

[Herfried K. Wagner [MVP]]

Currently I have a few excel file storing different range of data.
For eg. 1-100 in FileA; 101-200 in FileB; 201-300 in FileC...total 10 file.
I'd like to save these set of data to a recordset so that I can do some
update on this whole set of data.

Are you sure you want to do that using VB.NET?

 

[Bharat Patel [MSFT]]

Phoebe,

The following article or the one referenced in there will help you.

306022 HOW TO: Transfer Data to an Excel Workbook by Using Visual Basic .NET
http://support.microsoft.com/?id=306022


Hope this helps!
Bharat Patel
Microsoft, Visual Basic .NET

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to newsgroups only. Thanks.