Excel Data to SQL Database

[mpadgett]

I just finished taking an SQL Programming class to get an understanding of SQLs coding syntax and capabilities.

What I want to do now is take an Excel spreadsheet and code it to INSERT some specific data into a table in our SQL Database.

Currently I've coded the spreadsheet, with VBA, to email itself as an attachment to a user in another depart who then manually enters the data.

Should I code the SQL INSERT with VBA or write an external SQL Procedure on the SQL Server and execute it with VBA passing variable values to it?

Also, any suggestions regarding getting started with the appropriate code in VBA would be much appreciated.

Thanks - Mike P.

 

[RonRepp]

If you can, use a Stored Procedure. It's much faster.

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.