Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [TableName] ([Date] string, [Container] string)
- using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\test.xls;Extended Properties='Excel 8.0;HDR=Yes'"))
- {
- conn.Open();
- OleDbCommand cmd = new OleDbCommand("CREATE TABLE [TableName] ([Date] string, [Container] string)", conn);
- cmd.ExecuteNonQuery();
- }
Add Comment
Please, Sign In to add comment