Importing a common table from a number of DB's

N

Nath

Hi,

I have a number of DBs that i wish to import a common
table (tbl_main_data) into a common "central" database
(main_db)

The minor database names are written into an array :

Useer_db_names (10)

What i want to do, is to cycle through this array and
import the tbl_main_data from each, into tbl_main_data in
the central database from a module within the central
database.

Can anyone help.

TIA

Nath.
 

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

import hyperlink from excel to access 1
Importing to DB from excel file several columns from different tables 11
Import Errors table? 1
Automate Import of Spreadsheet to Backend from Frontend 1
Error while importing tables 1
Auto update of Access DB from 3 other Access Databases 1
Auto-Numbering in a Table in MS Word 1
Problem with table relationships when importing from SQL Server 2005 3

Top