Making ETL from Access 97 to Access 2003

[rusi]

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.