Extracting data from Access

  • Thread starter Thread starter Hari
  • Start date Start date
H

Hari

Hi All,

What is the efficient way to extract the data from
multiple access databases to a data file based on a user
input?

I want the extraction to be carried out with minimal user
intervention / setup.

Kindly suggest possible approaches.

TIA,
Hari
 
that's a pretty vague question. based on the limited information, suggest
you create a "frontend" database, link in the tables needed from the other
dbs, build queries to extract the data you want, build form(s) for the user
to provide the input needed for the queries to run, and output the data as
whatever kind of file you need.

hth
 
Back
Top