When I first started off I was using ODBC to connect to Excel, Access and then began to experiment with other front ends and connecting different ways to Excel and Access. I started using the OLEDB connection strings and ADO. Partially because of the way the data was imported into Excel and Access and the lack of control. With OLEDB and ADODB I can leverage VBA in the applications and give the front end more interactive use. Through input boxes and variables passing them through to the SQL statement. With ODBC it seems very limited and static.

As I begin to embark on my journey using WebMatrix 3.0 I am wondering what API's are recommended for an ASP.NET environment. I suppose it depends will be the answer.