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
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