Hi,

I'm trying to do a SELECT * and have the results return to me as though I would have done it via the query method through vba code... but not sure how to do it...

Tried doCmd.runSql doesn't work... and I have not other ideas...

thank you

Normally you open a connection and recordset using DAO or ADO. I use ADO exclusively since I do a lot of Access/SQL. The real issue is, what do you want to do with the data? That will determine the best method to use.

mmcdonal

Look it up at: http://wrox.books24x7.com

Hey,

I would want the data to appear just the same way as if I would have done the query through the query method in Access... I just want the data to show up on the screen... all of it...

Disregard... figured it out by taking a round about way of doing it...

    Dim objExcel As Object
    Dim sqlStr As String
    Dim objWBs As Object, objXLWB As Object

    sqlStr = "SELECT * INTO TempReport FROM Table_Name WHERE cell = val"

    'Insert data into a temporary table, then output the file to an xl file.
    DoCmd.RunSQL (sqlStr)
    DoCmd.OutputTo acOutputTable, "TempReport", acFormatXLS, "output.xls"
    DoCmd.RunSQL ("DROP TABLE TempReport")

    'Open said excel file...
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    Set objWBs = objExcel.Application.Workbooks
    objWBs.Open FileName:="output.xls", UpdateLinks:=1