Link Tables

[ziggyplayedgtar]

Hi
I'm quite new to all this, and at the moment feeling really stupid
The problem is I work in a large office, with 9 different servers (using NT) and I have 9 databases, one on each server, for users to update. Each quarter, I have to collate all the info entered and put into one database. I've tried for a week now to 'import' and 'link' these tables, but to no avail. Can someone please help me?

 

[Calvin]

link to each of the 9 tables on the different servers, then write 9 Append queries that will add the remote data to a local table and then to get this all to happen at once, assemble a macro executing each of the append queries one after the other or write a function in a module that does the same.

 

[ziggyplayedgtar]

No, I want to do it, but obviously don't have the necessary to do so. That's why I'm here. I got very bogged down after linking all the tables (5 in each db) and not a little confused. 2There's gotta be a better way" I thought!

 

[Calvin]

There is but it is code intensive and provides more flexibility for complex processes but what your doing sounds simple enough that what i suggested with using Append Queries should suit you fine as long as you do keep it straight and don't get to confused. Good Luck.

 

[ziggyplayedgtar]

Many thanks, I'll try tomorrow.