You are currently viewing the BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
I am trying to write a VB program that reads an Excel spreadsheet and writes to a SQL database. This subject is NOT covered in this book, as far as I know.
Where can I find information on how to access the Excel Object model? Most of what I have found is out of date or very detailed. I need a good overview in order to get started.
If you google "reading excel with vb.net", you'll get a bunch of examples on how to read Excel workbooks using VB.NET. Since the book already covers inserting data into SQL Server you should be able to put the two together.
VB 2008 accessing Excel Spreadsheets
