How To Use Excel To Create Large SQL Insert Statements

When adding records to a SQL database, simple 'Insert Into' statements can be used. This will add one record per Insert statement. It may be the case that there is no user-friendly import system set up and the records must be entered manually with this method. It is not always the case that records are received one at a time. Sometimes a large amount of data is given all at once, particularly if the database is in the initial set up stage. Data is often given in the format of an excel spreadsheet and it is up to the user to import the data into the database. It would be impractical and time consuming to update an individual insert statement for each record. Instead it is possible to use excel as a resource to quickly and simply create a series of Insert statements which will also minimise human error.

The full article appears here:
http://www.microsofttraining.net/article-896-how-use-excel-create-large-sql-insert-statements.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com