Updating a database from an Excel spreadsheet in .NET

Can Teradata tables be updated in an VB.NET application by reading an E开发者_运维问答xcel spreadsheet and pulling certain values from certain columns? If so how?

---

Yes.

This link shows how to read from a server database and update Excel, via ADO.NET and two OleDb connections.

It should be easy to modify that code to do the reverse. ; you'd just need to swap the connection strings shown in that code, so that the source is Excel, and the destination is your Teradata db.

There are some Excel-specific things in the queries, but you get the idea.

NB: This is not Excel Automation. It uses ADO.NET to read/update an Excel sheet. You don't need Excel to be installed on the machine in order to do these queries.