Save Excel File Data to recordset

  • Thread starter Thread starter Phoebe
  • Start date Start date
P

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.
 
* "Phoebe said:
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.
Click to expand...

Are you sure you want to do that using VB.NET?
 
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.
 
Back
Top