I try to create an Excel (2003) Sheet with ADO.NET (OleDb).
I was able to create the Sheet with an OleDbCommand:
var cnnString = "Provider=Microsoft.Jet.OLEDB.4.0;...";
var cnn = new OleDbConnection(cnnString);
var cmd = cnn.CreateCommand();
cmd.CommandText = "CREATE TABLE MySheet (ID char(255), Field1 char(255))";
That works as expected.
Here my Question:
What DataTypes (like char(255)) are Supported by Excel within the CREATE TABLE command? I did google but didn't find any documentation or hints.
Thanks for your help.
以上就是Creating an Excel Sheet with ADO.NET (OleDb) --> What DataTypes are Supported?的详细内容，更多请关注web前端其它相关文章！