I am in the process of writing a couple of routines to dump an ADO recordset or a ADO.NET datatable to XLS files using OleDb. I'm using a connection string like
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=""Excel 8.0;HDR=YES;MaxScanRows=0;IMEX=0;Mode=ReadWrite;""
and sql statements like
CREATE TABLE [sheetname] ( name TEXT, age NUMBER )
and so on. The problem is that the only documentation I could find is online posts and articles! Where is the reference guide for that kind of connection strings and that kind of SQL?
Aucun commentaire:
Enregistrer un commentaire