external use of an Access Table

[Ray C]

I have a a table in Access that holds some information that I need to use in
EXcell for the time being. Is it possible to have Excell work directly with
information held in an Access Table. I currently resolve the problem by
exporting the Table to Excell and then using Vlookup to access the data. This
means I have 2 versions of the same data and that is not good. it would be
good to do something like a lookup from within Excell but looking up
information held in an Access Table rather than another Spreadsheet.
Is this possible?
Thanks RayC

 

[Larry Daugherty]

We have a deal with the Excel folks: They won't guess and tell what
Access can or can't do and we'll be equally mum about Excel
capabilities.

It would seem to be an easy matter to open your version of Excel and
see what it offers in the way of getting external data.

HTH

 

[Klatuu]

You can use MS Query to pull data from an Access database. To do this, from
the Excel menu
Data, Import External Data, New Database Query
You will get a dialog "Choose Database Source"
Select MS Access Database*
Click OK.
Select the Directory the database is in from the right hand list box.
Select the database file from the left hand box
Click OK.

Now you will have a Query Wizard. You can select the tables and fields you
want to include in your query.

The next screen provides filtering options
The next screen provides sorting options
Then you can save the query if you want to by giving it a name
Then you will be asked to specify a location in the worksheet to put the data.

If you save the spreadsheet, it will store a copy of the data in the
spreadsheet.
Next time you open the spreadsheet, you can refresh the data by selecting
Data, Refresh Data.