On 11/8/2011 1:51 PM, Jarvis, Matthew 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... > > > > I want to open up 2011Qtr1 and append the rows from all the other MDB's > Accreditation table to build a full list. > > > > (One of) the problems I am running into is that Access (burn in hell) > wants to do APPEND commands in a sort of "from HERE" to "THERE". IOW it > appends data by pushing it from 2011Qtr2.Accreditation into > 2011Qtr1.Accreditation. It's totally bass-akwards of the way we do > things in VFP... > > > > I am going to have something like 11 years of this data, one quarter at > a time, and want to automate this as much as possible. I just can't get > my head around how to do this and have decided to just punt...
A quick thought: make remote views, grab all the data in, then combine them into one large mess, er, uh, I mean database. If the output must be an Access database, you can then use a utility or SPT to write the clusterbang back to Access. I think Craig Boyd has such a utility? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: ProFox@leafe.com 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/4eb97f54.60...@mbsoftwaresolutions.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.
