Extract Database

G

Guest

I used Crystal Report to extract databases. Which let us use simple criteria
to filter the results. Could use Excel which is linked to database to extract
only the data I want? For example in the following format:

Criteria Qty
Customer A Product A 1
Customer A Product B 3
Customer C Product A 23
Customer C Product B 2

I hope the criteria could be set, but the quantity will be refresh from the
database every month.

I appreciate your help.
 
D

Diva

It is very simple using Excel. Under menu "Data", select "Import
external data" and then select from the sub menu "New data base query".
A wizard will appear. In one of the steps of the wizard you can give
criterion very easiely. After that whenever you want latest data,
simply refresh.
Divakar
 

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

COUNTIFS with No Criteria 1
Please Help! Normalization Exercise 1
Access Passing the value to a table 1
How to do summation of unique counts based on another variable? 3
Date criteria for adv. filter in code 3
double Sum if criterias ! 2
loops 3
Referencing dates against Products, in order to find the Qty. Without using Column referencing 1

Top