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
 
You must log in or register to reply here.

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

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
how to extract data from Jet database .db file 0
What are the steps to fix damaged MDF files in SQL Server? 0
Extracting data from Excel to Access db table 2
Macros to extract data frommultiple workbooks to a master workbook 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0
How to omit 25 rows of header while importing data to access 4
Import data from ODBC 1

Back
Top