mercredi 25 mars 2015

Microsoft.Jet.OLEDB.4.0 excel/sql documentation

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