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

Open & Read Excel files from VB.NET

P: n/a
Need to update all records in a table from a simple Excel worksheet (1
sheet with 5 columns).
I need help with the basic steps to open and read each data row in the Excel
file.
Thanks a million

Bill
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The following KB article may be useful.

http://support.microsoft.com/default...b;en-us;316934

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Bill Nguyen" <bi*****************@jaco.com> wrote in message
news:u2**************@tk2msftngp13.phx.gbl...
Need to update all records in a table from a simple Excel worksheet (1
sheet with 5 columns).
I need help with the basic steps to open and read each data row in the Excel
file.
Thanks a million

Bill

Nov 21 '05 #2

P: n/a
Thanks David.
This is what I need for a simple read.
I ran into a problem with embedded single quote "'" in a text column,
causing my INSERT clause to fail. How can I remove the single quote before
executing the sql?

Bill

"David Lloyd" <Ne********@LemingtonConsulting.com> wrote in message
news:%L*******************@bignews4.bellsouth.net. ..
The following KB article may be useful.

http://support.microsoft.com/default...b;en-us;316934

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or
warranties.
"Bill Nguyen" <bi*****************@jaco.com> wrote in message
news:u2**************@tk2msftngp13.phx.gbl...
Need to update all records in a table from a simple Excel worksheet (1
sheet with 5 columns).
I need help with the basic steps to open and read each data row in the
Excel
file.
Thanks a million

Bill

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.