Prev: Column Not showing after pick in combo box
Next: Access 2003 cannot open .mde made by Access 2007?
From: Ray C on 18 Jun 2008 17:46
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
From: Larry Daugherty on 18 Jun 2008 18:57
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
--
-Larry-
--

"Ray C" <RayC(a)discussions.microsoft.com> wrote in message
news:21BC56AF-3509-48BA-A242-6AD63BE93724(a)microsoft.com...
> 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


From: Klatuu on 19 Jun 2008 11:32
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.
--
Dave Hargis, Microsoft Access MVP


"Ray C" wrote:

> 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
 | 
Pages: 1
Prev: Column Not showing after pick in combo box
Next: Access 2003 cannot open .mde made by Access 2007?