Running Access from XL

["Walter Lake" <wlake@xxxxxxxxx>]

This appeared on the XL-L List

Record this procedure with the VBA / macro recorder to get the details of
the code.

Best regards

Walter

================

"... here's what I do quick and dirty

open a new workbook then use the menu item

Data --> Get External Data --> Create New Query

To open the "Choose Data Source" dialog

Select MS Access 97 from the list and click OK

This will bring up the select database dialog.  Navigate to your database
and select it, click OK.

This will launch the Query Wizard where you select the table and fields to
link to you workbook.

Select at least one field and install it in the right hand panel. Click
Next>

Now add any filter information to narrow the query in the filter dialog or
do nothing to get all data in the field(s) selected

Click next and add sort info to the query

Click next and select return the data to Excel

Click Finish and select the cell where the data will go

By now you should have a list of data in you excel workbook

At this point all that remains is to set the ListFillRange property of the
combobox to the range of data just created.

..."