VS2010数据源创建Excel文件代码示例

private:System ::Void button1_Click(System::Object^ sender,System::EventArgs^ e){
string^ MyFileName;
string^ MyTabelName;
string^ MySQL;
try
{
MyFileName=this->textBox1->Text;
MyTabelName=this->textBox2->Text;
if(MyTabelName->Length<1)
{
 MessageBox::Show("请输入数据表名！","信息提示",MessageBoxButton::OK,MessageBoxIcon::Information);
 return;
}
if(MyFileName->Length<1)
{
 MessageBox::Show("请输入excel文件名"，"信息提示"，MessageBoxButton::OK,MessageBoxIcon::Information)；

}
MySQL="Create Tabel "+MyTableName+"("+this->richTextBox1->Text+")";
this->oleDbConnection1=gcnew System::Data::OleDb::OleDbConnection();
this->oleDbConnection1->ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+MyFileName+";Excel 8.0;HDR=YES";
this->oleDbconnection1->Open();
this->oleDbCommand1=gcnew      System::Data::OleDb::OleDbCommand(MySQL,this->oleDbConenction1);
this->oleDbCommand->ExecuteNonQuery();
this->oleDbConnection->Close();
MessageBox::Show("excel文件： "+MyFileName+"创建成功！","信息提示",MessageBoxButtons::OK,MessageBoxIcon::Infromation);
}

catch(Exception^ MyEx)
{