While pulling into VFP might be fun (& fast!), there are a some gotchas like weird column names in Access getting munged via ODBC. In theory, you should be able to use a SELECT ... UNION to get one big table/cursor which could then be dumped into the current what you want or maybe even do one DB at a time with an INSERT INTO ... SELECT * FROM ... . That's about as close as I could come to APPEND FROM. I don't have Access installed here so don't know how easy or hard it is to do something like that. And as others have pointed out, large datasets and issues with primary keys may bite you either way.
If you have SSMS handy, you might be able to use SQL Server to help you get the data consolidated in a more efficient way than Access allows. -- rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Tuesday, November 08, 2011 1:52 PM To: profoxt...@leafe.com Subject: [NF] MS Access question on APPEND-like functionality 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... Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD0441D438F2D49@ACKBWDDQH1.artfact.local ** 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.
