Bob Bob - 1 year ago 79
SQL Question

Excel Cells to ADODB.Recordset

I have an Excel spreadsheet that I want to make into an

. I've done this with an Excel table before, but not just cells. The
are in row 4 while the
are in row 5. Everything before and after that is just visual garbage such as Title etc.

Normally I would just do something like
getSomething = MyADO.executeQuery("SELECT * FROM [Worksheet$]")
, but I'm lost on what to do here and how to test that it works.

Answer Source

This works for me (testing with ADO in Excel VBA tho...)

getSomething = MyADO.executeQuery("SELECT * FROM [Worksheet$4:5]")
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download