Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 19, 2012 05:30 AM by Decker Dong - MSFT
All-Star
118619 Points
18779 Posts
Apr 19, 2012 05:30 AM|LINK
mannnn yup same error..
yup same error..
This seems to be a little strange……Well, let's try another way：
1）File - > Save As - Microsoft Excel 97-Excel 2003 &5.0/95 workbook(*.xls)
2）Then do this：
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Drive\\Training_Template.xls;Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""" OleDbConnection DBConnection = new OleDbConnection(strConn);
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: "External table is not in the expected format"
Apr 19, 2012 05:30 AM|LINK
This seems to be a little strange……Well, let's try another way：
1）File - > Save As - Microsoft Excel 97-Excel 2003 &5.0/95 workbook(*.xls)
2）Then do this：
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\Drive\\Training_Template.xls;Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""" OleDbConnection DBConnection = new OleDbConnection(strConn);