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?
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access #Error & Excel Pivot 0
Running Make Table Access Queries from Excel 3
Import data from Access to Excel containing VB code 3
Transferspreadsheet not working 1
Help with VBA code in macro 6
Help VBA in macro 1
How can you generate an Excel file from a query that has parameter 4

Back
Top