Merging MDB files
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

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,

Anoop

Report | Quote This | Send private message | Reply | Print

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.

Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact