<div>
Select * From [Sheet1$]<br />
Select Column1 From [Sheet1$]<br />
<br />
Bob
</div>


Select * From [Sheet1$]
Select Column1 From [Sheet1$]

Bob

<div>
<div class="content wysiwyg-content">
I figured out how to connect to the Excel spreadsheet in my code, but the only thing holding me back is how to write a query string in vb.net with OLE DB. &nbsp;How would I do a simple select * from (excel spreadsheet) and how would I do a select column1 from (excel spreadsheet)?<br />
<br />

</div>
</div>


I figured out how to connect to the Excel spreadsheet in my code, but the only thing holding me back is how to write a query string in vb.net with OLE DB.  How would I do a simple select * from (excel spreadsheet) and how would I do a select column1 from (excel spreadsheet)?



How would you do a connection string in OLE DB and write a select * from Excel spreadsheet query?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,