reading and writting excel format/or using ado.net

[djkno3]

I'm trying to figure out how to read in an excel file then put some extra values in the spreadsheet. The problem I have (I looked up in the msdn and they gave me "Driver={Microsoft Excel Driver (*.xls)};DBQ=Excel test.xls" for a connect string. The problem is when I run it it tells me I need to put a Provider= in it. That would be great if I could find the string for the provider. I'm working with Office 2000 and office xp. another question is would Crystal Reports be better to use? I'm not doing any major manipulation of the spreedsheets I'm just reading them in to find where to put the data so I don't overwrite anything and then inserting some rows and colums. Thanks for the help.