I read about a free utility program at this post. I followed the link, it says it will do what you want to to, but I have not tried the script. Look for CSVdb.
http://www.gossamer-threads.com/...i?post=235184#235184
When faced with your situation, I do the following, download the .db file, open it in notepad, copy all, paste into a spreadsheet, parse into columns, add the columns as needed, copy all, paste back into notepad, search and replace to get the correct delimiter, make sure ther is NOT a new line and the end of the file, sent the .db file back to the server.
The only real problem is that if a User logs on and adds a record while I am editing ... so you disable log on while editing your .db file.
http://www.gossamer-threads.com/...i?post=235184#235184
When faced with your situation, I do the following, download the .db file, open it in notepad, copy all, paste into a spreadsheet, parse into columns, add the columns as needed, copy all, paste back into notepad, search and replace to get the correct delimiter, make sure ther is NOT a new line and the end of the file, sent the .db file back to the server.
The only real problem is that if a User logs on and adds a record while I am editing ... so you disable log on while editing your .db file.
