On Tue, Nov 8, 2011 at 12:51 PM, Jarvis, Matthew <[email protected]> wrote: > Since it's been slow, at least this will be something to talk about... > First of all - Access TOTALLY SUCKS in case you didn't know.... > > > > I am trying to pull together data from like-named tables that exist in > separate MDB files. > > > > For example I have 4 DB's, each with a table called "Accreditation". > > > > My MDB's are called 2011Qtr1.mdb, 2011Qtr2.mdb, 2011Qtr3.mdb, etc... --------------------
You have SQL Server there so use that! Screw Access. If you have SQL 2000 the process of setting up the ETL is different but easier then how it is done in SQL 2005 or 2008. (IMHO) You can suck all three or four tables at the same time into a single table in SQL Server and just report off of that in Access (LOL) -- Stephen Russell 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjfmvzjoxoqbzlk-eclocckzdhwytszfaxbsxflmwh...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
