RE: Importing Data from Access into Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

That's not a lot of information to go on, but....in general, you could start
with:

1)Select the cell where the data pull will begin to store the Access data
2)Data>Import External Data>New database Query
3)Select the MS Access data source
4)Select the table(s) you need to use and progress through the MS Query
screens.
5)At the end, you can either select to edit the query or just send the data
back to Excel.

6)Repeat for each *** that is to receive the MS Access data.

Thereafter, you only need to select a cell in the data range and Data>Refresh

Does that help?

--
Regards,
Ron

.

Quantcast