Open & Read Excel files from VB.NET

  • Thread starter Thread starter Bill Nguyen
  • Start date Start date
B

Bill Nguyen

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Run Unix shell script from VB.NET 4
Access #Error & Excel Pivot 0
Simple VB6 read and write converted to vb.net? How to Read CSV???? 5
late binding when vb.net 2005 updates excel 2003 2
Reading Excel in VB.NET 6

Back
Top