I loved your article on transferring Word form data to an Excel sheet at http://www.techrepublic.com/blog/10things/10-steps-to-transferring-word-form-data-to-an-excel-sheet/3484. The code uses an INSERT INTO SQL string, which writes over existing data. I’d like to append each record to an existing set of records. Any help would be appreciated. — Chris
Chris, you’ll be glad to hear that your problem has an easy solution: use the SELECT INTO SQL statement. Below, I’ve included two tutorial-type links to bring you up to speed on this statement:
The SELECT INTO statement will append each new record into an existing table.