impoting Access Data to Excel

  • Thread starter Thread starter celica06
  • Start date Start date
C

celica06

I can automatically refresh the data in a worksheet if the query imported
from ACCESS was a SELECT QUERY. I cannot, however, import and use an ACCESS
parameter query. Any thoughts?
 
Suggestions other than "don't use a parameter query", right? < grin >

Even if you were to do the export from ACCESS to EXCEL, you still cannot use
a parameter query as the source of data for the export/import. The
export/import processes will not ask you for the parameter, so somehow you
need to have the parameter value actually be in the SQL statement for the
query before you export/import the data.

To assist you on how you might do that, please give us more details about
your particular setup, data, query structure, and needs. Is it possible for
you to export from ACCESS instead of importing from EXCEL?
 
Back
Top