can't open recordset starting with SQL "transform"

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi Scott,

Not terribly familiar with the ADODB syntax, but it seems
that with the .open method, you wouldn't need single
quotes around your sql statement:
rstMyRecords.Open "'" & MyString & "'",
CurrentProject.Connection

The other syntax error in your sql statement that's
probably causing the error is that there is no semicolon
after your TRANSFORM....statement. Put it within the
double quotes but after the last word.

If it still doesn't work, there is a way to get around
this to get your data into excel (using the pivot table
feature in excel). The big problems I've run into using
this is that if I'm opening up the excel file from access,
it doesn't refresh the data even though I've set the query
property in excel to refresh on open. So I just have my
users (very small group) open up the excel file directly
and it refreshes like a charm.

Hope it works!

Regards,
Jen
 
Back
Top