Could not find installable ISAM

[DeelynBaNi]

Hi, can anyone help me with this? The error 'Could not find installable ISAM' occured when i tried to export data from excel to sql server express. excel installed in my computer is office 2007.

string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtSource.Text.Trim() + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1;\"";
OleDbConnection connection = new OleDbConnection(excelConnectionString);
connection.Open(); <--error here

[Curtis Rutland]

From what I've read, that error comes up when your connection string syntax is incorrect. Check www.connectionstrings.com and look up excel. Make sure you are doing it right.

Also, if this is for Excel 07 (.xlsx) you have to use ACE, not JET.

[DeelynBaNi]

From what I've read, that error comes up when your connection string syntax is incorrect. Check www.connectionstrings.com and look up excel. Make sure you are doing it right.

Also, if this is for Excel 07 (.xlsx) you have to use ACE, not JET.

I already check the connection string but still same problem. I've tried many ways i can find about the connection string syntax but the problem still there.

conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + xtSource.Text.Trim() + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1;\"";

conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + tSource.Text.Trim() + ";Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1;""";


Excel installed in my computer is excel 07 but the excel file i created is .xls. So that means i use JET right?

[Curtis Rutland]

Well, I'm not sure. Try using ACE and see if that solves your problem. (You can look up an Excel 2007 conn string)

Also, try to output your completed conn string. There may be a mistake in the input text. Make sure that the completed string looks correct.

[DeelynBaNi]

Well, I'm not sure. Try using ACE and see if that solves your problem. (You can look up an Excel 2007 conn string)

Also, try to output your completed conn string. There may be a mistake in the input text. Make sure that the completed string looks correct.

insertAlias thanks for your help. My connection ok already. I need to format the columns in excel first in order to make my connection ok.