My project tool will build SQL statements for you too.

The tool will also validate and send the data directly from Excel if you wish.

The app will generate Insert statements using a template and merge code system.

Here is an example template :

INSERT INTO Customers

(

"Short Name",

"Name",

"Contact First Name",

"Contact Surname",

"Address",

"Town",

"Zip/PostCode",

"Days Credit",

"FirstOrder"

)

VALUES

( '{XL-merge:Short Name}',

'{XL-merge:Name}',

'{XL-merge:Contact First Name}',

'{XL-merge:Contact Surname}',

'{XL-merge:Address}',

'{XL-merge:Town}',

'{XL-merge:Zip/PostCode}',

{XL-merge:Days Credit},

'{XL-merge:FirstOrder}')

Templates are auto generated after you select a destination table or procedure.

The application will validate all of your data by wrapping the operation in Transaction, and reporting any errors and the reason for the error against each row.

You can modify the template SQL as you wish - changing it to Update or conditional insert / update or execute stored procedure if you wish.

Its free for 60 days and could save you allot of time 😉

C# Gnu
____________________________________________________

Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015