By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,219 Members | 2,147 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,219 IT Pros & Developers. It's quick & easy.

Save Excel File Data to recordset

P: n/a
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.
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "Phoebe" <ph********@hotmail.com> scripsit:
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?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #2

P: n/a
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.

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.