Append records to existing table using SELECT INTO

I loved your article on transferring Word form data to an Excel sheet at 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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s