Merging MDB files
1 posts in topic
Flat View  Flat View

Posted By:   Anonymous
Posted On:   Monday, July 9, 2007 03:27 AM

Hi all,

I have around 65 mdb files which is used by 65 users to enter data. All the 65 mdb files have same schema and non redundant data. what i want to do is to write one java file which will merge all this 65 mdb files into one single mdb file. Can anyone please help me?

Thanks in Advance,
Happy Coding,


Re: Merging MDB files

Posted By:   David_Thornton  
Posted On:   Monday, July 9, 2007 08:55 PM

Connect to target MDB
For each source MDB file
Connect to source MDB
For each table in source MDB
select from source table
for each row in result set
insert into target table
Disconnect from source MDB
Disconnect target MDB

For the details have a read of the JDBC Trail in the Sun Java Tutorial.

About | Sitemap | Contact