TransferSpreadsheet Method and SQL

[Brad]

Thanks for taking the time to read my question.

I want to use SQL in the TransferSpreadsheet Method, but I can't get it
to work.

I don't know why, because I've done a debug.pring on the same code to
see what the code resolves to and it looks just like the select
statement in the query I based it on.

I want SQL in there so that it can be dynamic. Any table, and any date
field in that table.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
"SELECT " & Me.cboTableNames & ".*, " & Me.cboTableNames & "." &
Me.cboDateFields & " " & _
"FROM " &
Me.cboTableNames & _
"WHERE ((("
& Me.cboTableNames & "." & Me.cboDateFields & ") Between #" &
Me.txtStartDate & "# And #" & Me.txtEndDate & "#));", Me.txtSaveTo & "\"
& Me.txtFileName
 
 

The error I get is: Error Number 3011, The Microsoft Jet Database Engine
could not find the object 'the sql I wrote goes in here'. Make sure the
object exists and that you spell its name and the path name correctly.

Thanks again for your help.

Brad

*** Sent via Developersdex http://www.developersdex.com ***

[fredg]

On Mon, 15 May 2006 17:57:40 GMT, Brad wrote:

Thanks for taking the time to read my question.

I want to use SQL in the TransferSpreadsheet Method, but I can't get it
to work.

I don't know why, because I've done a debug.pring on the same code to
see what the code resolves to and it looks just like the select
statement in the query I based it on.

I want SQL in there so that it can be dynamic. Any table, and any date
field in that table.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
 "SELECT " & Me.cboTableNames & ".*, " & Me.cboTableNames & "." &
 Me.cboDateFields & " " & _
                                                              "FROM " &
 Me.cboTableNames & _
                                                              "WHERE ((("
 & Me.cboTableNames & "." & Me.cboDateFields & ") Between #" &
 Me.txtStartDate & "# And #" & Me.txtEndDate & "#));", Me.txtSaveTo & "\"
 & Me.txtFileName

 

The error I get is: Error Number 3011, The Microsoft Jet Database Engine
could not find the object 'the sql I wrote goes in here'. Make sure the
object exists and that you spell its name and the path name correctly.

Thanks again for your help.

Brad

*** Sent via Developersdex http://www.developersdex.com ***

i believe you must use a named database object (table or query).
Create a query, using your SQL.
Use the query name (in quotes) in place of your SQL.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail