Last post Dec 18, 2010 07:51 AM by zestq
Dec 18, 2010 05:21 AM|dcwmorley|LINK
I am trying to import some data from an Excel spreadsheet. With the following code, I am getting a "Could not find an installable ISAM" server error and it highlights the last line of the snippet given below.
I think this message often means that there is an error in the connection string, but I can't see what the problem is and trial and error hasn't worked yet.
Can anyone spot the problem, please ?
Dec 18, 2010 05:53 AM|kedarrkulkarni|LINK
if you have excel 2003... then this connectionstring should work....
i tried to find any error in u r connecctionstring from here
only diffrence i can locate is...
extended properties is writen as extendedProperties (no space)
i m not sure if that can cause any issue... u can try..
if filepath is varialbe which holds actual file path... then it should have been
" ...... source = " & filePath & "; extednde properties = ""...blah blah
hope this helps...
Dec 18, 2010 05:58 AM|stanly|LINK
Hope this helps...
Dec 18, 2010 06:53 AM|mudassarkhan|LINK
Dec 18, 2010 07:01 AM|aspnet2sams|LINK
Are you targeting to get the data into tables of SQL server? if so, a side tracked solution u can try is of DTS services.
Dec 18, 2010 07:51 AM|zestq|LINK
I found this article which is a very detailed one you can check it:
for excel extension; xls u can simply use below query (using SP etc)
Insert into Supplier
(Supplier_Type_ID, Supplier_Name, Description, Status )
Supplier_Type_ID, Supplier_Name, Description, Status
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=D:\test.xls;Extended Properties=Excel 8.0')...Sheet2$
for excel 2007 i would recommecd to use SSIS package
let me know if further explanation reqd.
excel Data copying