Making ETL from Access 97 to Access 2003

[Paul Simon]

"rusi" <rustompmody at gmail.com> wrote in message 
news:92551c63-1347-4f1a-9dca-d1bbd5e4d112 at 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... at sonic.net> wrote:
> "rusi" <rustompm... at gmail.com> wrote in message
>
> news:ff550c58-58b0-4bf2-bf12-08986ab2b695 at ka6g2000pbb.googlegroups.com...
> On Apr 15, 5:27 pm, Steeve <steeve.h... at 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