Xls into table and back

[kelton5020]

Hey, I was wondering if anyone could help me figure out how to load an XLS file into a table in VB.net, and then save it when I'm done editing it. Thanks.

 

[Raven65]

Wow, third person today with Excel in mind. =)

Check out this thread where some discussion is started.

http://www.vbdotnetforums.com/showthread.php?t=14221

 

[kelton5020]

Ya that didn't really help me. I have to get this functioning quickly, and I don't have time to read through that whole deal right now. If someone could just show me the basics of opening a xls spreadsheet, updating it, and saving it back to xls that would be much appreciated. thanks.

 

[jmcilhinney]

Excel files can be treated like a database and accessed using OleDb. It's pretty much the same as using an Access database. You use a query to retrieve the data into a DataTable, edit it like you would any other table and then use an SQL statement to update the source. One OleDbConnection, one OleDbDataAdapter and one DataTable. www.connectionstrings.com has the details of how to connect for various data sources including Excel.

 

[kelton5020]

much thanks