Okay, here's a strange one. I have sqlite dbs for every day of the week. Every db is the same (contains 4 tables) as far as structure goes. Is there a method from the command line (on a win32 box) that I can use the sqlite.exe to merge 10 days (so 10 dbs) worth of data into a single "master" database? I was accomplishing this with 40 separate queries (4 for each of the 10 days) within Access 2k but it takes an ungodly amount of time. Just wondering if it was possible from the cmd line to speed it up. A vacuum takes a large amount of time as well, each of the database files range from 800-1200MB. This is 2.x by the way. Any help would be most appreciated. The archives didn't lend much help. ciao!
************************************************************************** The preceding message and any attachments may contain confidential information protected by the attorney-client or other privilege. If you believe that it has been sent to you in error, please reply to the sender that you received the message in error and then delete it. Nothing in this email message, including the typed name of the sender and/or this signature block, is intended to constitute an electronic signature unless a specific statement to the contrary is included in the message. **************************************************************************
