Importing of Access data

Y

Yanti

Hi,

I have an excel template which holds various data which
is currently being inserted manually. What I'd like to
achieve is to insert these data automatically from an
Access database. For example, I have a product database.
On the other hand I have an excel template that holds
data of all products, groupd in it's category. For
instance, in the cell A5, I'd like to extract a data from
the database, the qty sold for rugs where it's category
is household. How do I get to that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Using Access Database to build contracts with fields on pdf document 0
Email notifications without opening application 1
Extracting data/using COUNTIFS 2
sorting noncontiguous data with exceptions 3
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Import data from excel 1
Page numbering with Merged Document and IF statements 1

Top