"rusi" <rustompm...@gmail.com> wrote in message news:92551c63-1347-4f1a-9dca-d1bbd5e4d...@ys5g2000pbc.googlegroups.com... Its hard to distinguish what you are saying from what I said because you've lost the quotes.
On Apr 15, 9:01 pm, "Paul Simon" <psi...@sonic.net> wrote: > "rusi" <rustompm...@gmail.com> wrote in message > > news:ff550c58-58b0-4bf2-bf12-08986ab2b...@ka6g2000pbb.googlegroups.com... > On Apr 15, 5:27 pm, Steeve <steeve.h...@gmail.com> wrote: > > > Hi, > > > I need to take data from 5 differents (but similar) database in MS > > Access > > 97 and merge them into one MS Access 2003 database. > > Not sure what this had to do with python. > However > You could write out the five as csvs and then read in those csvs. > This is assuming that access 2003 cannot read in access 97. [Seems a > bit surprising though] > > > > > Is some packages exist to do this task? > > Dunno > Have you seenhttp://allenbrowne.com/ser-48.html? > > If there are indices and especially linked primary and foreign keys its > much more complicated than that. One has to delve into Access container > structures etc. As far as I know it has to be done from Access. I assume you are saying this for my csv suggestion? Yes of course. I gave this as the last resort if direct import and other such attempts dont work out. >>>Could you please append your comments instead of splitting them? >>>Let me try to be clearer. If one only wants to merge tables, csv will >>>work fine, exporting them from Access. >>>Reconstucting keys and relationships can be done with some difficulty >>>using Access' container model. See the Developer's Handbook by Getz, >>>Litwin and Gilbert. >>>Paul Simon
-- http://mail.python.org/mailman/listinfo/python-list