Can I use Access Queries in Excel? 1

[drmichaelw]

Every week I need to download a 30MB file into excel. I can create queries in excel, however they take too long to execute on such a large file. Is there a way I can create the queries in Access and run the queries on the excel worksheet. Will this improve performance. Right now the performance on the queries written in Excel is unacceptable. I am trying to avoid exporting such a large file to Access, run my queries, and then export the results back to excel.

 

[DseeDm]

Hi

You could try linking to the excel spreadsheet,
like it's a table...

Not sure if this will increase efficiency

Good Luck
-DCD

 

[drmichaelw]

Thanks for your respone. How do you link to the table?

 

[DseeDm]

Hi,

Select File > Get External Data > Link tables