Hi all, how can I create a connection to excel file and view the result in vb. I am using visual studio 2008, I have been trying to look for answers around but could not find one that teaches step by step.And what references do I need to use? Thanks in advance.
Regards Jason
This link may help you. It's a simple example, but may guide you to what you are trying to do with it.
If you're wanting to treat the contained worksheets of a workbook as tables consider using an OLEDB driver to query the data as you would a database. It's cleaner than Excel automation if you only care about the data. Check out this tutorial.