<div>
Are you using VB to open the spreadsheet, or are you using VBA (within Excel, itself) - that is VBA in an Excel macro?
</div>


Are you using VB to open the spreadsheet, or are you using VBA (within Excel, itself) - that is VBA in an Excel macro?

<div>
In Excel you can use the QueryTables.Add method to add data to a sheet:<br />
<br />
Dim qt As QueryTable<br />
sqlstring = &quot;select 96Sales.totals from 96Sales where profit &lt;&nbsp;5&quot;<br />
connstring = _<br />
&nbsp; &nbsp; &quot;ODBC;DSN=96SalesData;UID=<wbr />Rep21;PWD=<wbr />NUyHwYQI;D<wbr />atabase=96<wbr />Sales&quot;<br />
With ActiveSheet.QueryTables.Ad<wbr />d(Connecti<wbr />on:=connst<wbr />ring, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; Destination:=Range(&quot;B1&quot;), Sql:=sqlstring)<br />
&nbsp; &nbsp; .Refresh<br />
End With<br />
<br />
(example from Excel help)<br />
<br />
D'Mzzl!<br />
RoverM
</div>


In Excel you can use the QueryTables.Add method to add data to a sheet:

Dim qt As QueryTable
sqlstring = "select 96Sales.totals from 96Sales where profit < 5"
connstring = _
    "ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;Database=96Sales"
With ActiveSheet.QueryTables.Add(Connection:=connstring, _
        Destination:=Range("B1"), Sql:=sqlstring)
    .Refresh
End With

(example from Excel help)

D'Mzzl!
RoverM

<div>
I am opening excel as an excel8 object<br />

</div>


<div>
Thanks everyone for their time .<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I need to return a recordset from an excel spreadsheet and total certain fields before I upload the data to an AS400 file. &nbsp;I already have the worksheet defined in VB. I need to know if its possible to use sql against the spreadsheet in this way.. &nbsp;Thanks in advance.<br />
<br />
God Bless America<br />
<br />

</div>
</div>


I need to return a recordset from an excel spreadsheet and total certain fields before I upload the data to an AS400 file.  I already have the worksheet defined in VB. I need to know if its possible to use sql against the spreadsheet in this way..  Thanks in advance.

God Bless America



sql against a spreadsheet

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.