Making ETL from Access 97 to Access 2003

2013-04-15 Thread Steeve
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. Is some packages exist to do this task? Thank -- http://mail.python.org/mailman/listinfo/python-list

Re: Making ETL from Access 97 to Access 2003

2013-04-15 Thread rusi
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

Re: Making ETL from Access 97 to Access 2003

2013-04-15 Thread Paul Simon
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

Re: Making ETL from Access 97 to Access 2003

2013-04-15 Thread 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...@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

Re: Making ETL from Access 97 to Access 2003

2013-04-15 Thread Paul Simon
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