naming an sql query to use in the transferspreadsheet

K

kfguardian

How do you name an sql query created for an ADO recordset to use in the
transferspreadsheet function?

Set cnThisConnect = CurrentProject.Connection
strSQL = "SELECT * FROM tblInputData " _
& "WHERE (InputDate >= CONVERT(DATETIME, '" & datQueryStart
& "', 102)) AND" _
& " (InputDate < CONVERT(DATETIME, '" & ShiftEnd &
"', 102))"

rstNewInputData.Open strSQL, cnThisConnect, adOpenKeyset,
adLockOptimistic, adCmdText
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

currentdb = nothing? 9
Export form that is not bound to table 0
Can't create querydef variable because "user defined type not defi 2
ADO query EOF problem 2
Assign recordset - subform 1
Query incorrectly returning no records in ADO 2
SQL Query To Recreate Task Usage 0
SQL QUERY in FUNCTION returns 0 value 1

Top