<div>
On the Data Tab, look at the &quot;Get External Data&quot; options, one of which is from Access.
</div>


<div>
Hi Rob,<br />
<br />
That's a manual process and works OK but I need to automate it so it's transparent to my client.<br />
<br />
Thanks,<br />
<br />
Bill
</div>


<div>
Hi Bill,<br />
<br />
In which case, I suggest you give some more detail to the question so that other EE users might be able to help further.<br />
<br />
Thanks<br />
Rob
</div>


<div>
Hi Rob,<br />
<br />
More detail...<br />
<br />
I have an Access database with 500k++ rows of data. &nbsp;In it we have several Access queries that pare the data down and that are exported manually to an Excel sheet. &nbsp;Users do not have Access installed. &nbsp;What I want to do is create an Admin sheet in a workbook that has buttons to import the various queries and format the sheets - or maybe just drop the data into pre-formatted sheets...<br />
<br />
The queries are parameter queries so I need to pass the parameters or the SQL to the Access DB. &nbsp;I suspect I will need to use VBA but not sure how to do this in Excel. &nbsp;I could do in an Access form - I'm just not familiar with Excel automation.<br />
<br />
What more information is needed?<br />
<br />
Thanks,<br />
<br />
Bill
</div>


<div>
Hi Bill<br />
<br />
Sorry but that is beyond my expertise so will have to bow out and leave it for other Experts to help you.<br />
<br />
Thanks<br />
Rob
</div>


<div>
You might create a querytable result in &nbsp;a worksheet and then update it when the workbook is opened.
</div>


<div>
Hi Experts,<br />
<br />
I've been pulled away from this project for a bit. &nbsp;It looks like there are several good options and I'll get back to it this week. &nbsp;Thanks for your help! &nbsp;I'll let you know the result.<br />
<br />
Bill
</div>


<div>
Hi Experts,<br />
<br />
I combined several of these. &nbsp;The real trick was getting the temp tables created and Helen - thanks for the tips! &nbsp;Solution is working nicely.<br />
<br />
Best,<br />
<br />
Bill
</div>


<div>
<div class="content wysiwyg-content">
HI,<br />
<br />
Is it possible to click a button in an Excel workbook and import a parameter query from an Access database into a new sheet in the same Excel workbook? &nbsp;I need to then format the sheet.<br />
<br />
Ideas?<br />
<br />
Thanks in advance. &nbsp;Bill
</div>
</div>


HI,

Is it possible to click a button in an Excel workbook and import a parameter query from an Access database into a new sheet in the same Excel workbook?  I need to then format the sheet.

Ideas?

Thanks in advance.  Bill

Excel as MS Access front end

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.