could not find installable isam error 7303
here for a quick overview of the site Help Center Detailed answers to could not find installable isam excel 2010 any questions you might have Meta Discuss the workings and
Could Not Find Installable Isam Access 2013policies of this site About Us Learn more about Stack Overflow the company Business Learn could not find installable isam c# more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community
Could Not Find Installable Isam Vb6Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to resolve “Could not find installable ISAM.” error for OLE DB provider “Microsoft.ACE.OLEDB.12.0” up vote 13 down vote favorite 1 I am trying to import data could not find installable isam word 2013 from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "Could not find installable ISAM" error. All hardware is 32-bit. [Revised 1/10/12 to try to focus more sharply on the anomalies] The following T-SQL statement produces the error: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Data Source=C:\work\TestData.xlsx;Extended Properties="Excel 12.0 XML;HDR=YES"', 'SELECT * FROM [Sheet1$]' ) If I save the Excel file in the "Excel 97-2003" format (.xls) and use the older Microsoft.Jet.OLEDB.4.0 provider to import the data, it works just fine. This makes me think it is not a security or other environmental issue. SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\work\TestData.xls;HDR=YES', 'SELECT * FROM [Sheet1$]' ) However, when I try the *.xls file with Microsoft.ACE.OLEDB.12.0 provider, which should be backward compatible with the *.xls format, it again fails with the same error: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Data Source=C:\work\TestData.xls;Extended Properties="Excel 8.0;HDR=YES";'
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search
Could Not Find Installable Isam Excel 2007Members Calendar Who's On Home » SQL Server 2005 » T-SQL
Could Not Find Installable Isam Office 2010(SS2K5) » Openrowset "Could not find installable... Openrowset "Could not find installable ISAM.". for Excel Import Rate could not find installable isam excel 2003 Topic Display Mode Topic Options Author Message joohn77joohn77 Posted Tuesday, June 7, 2011 1:14 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, December 30, 2014 http://stackoverflow.com/questions/8797978/how-to-resolve-could-not-find-installable-isam-error-for-ole-db-provider-mic 7:43 PM Points: 2, Visits: 81 Hi,I am trying to import data from an excel spreadsheet (2003) into SQL SERVER 2005 using openrowset on Windows Server 2003 SP2.SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\ImportFile.xls', 'SELECT * FROM [Sheet1$]')The query has been working fine for a few weeks then recently we started to get this error:OLE DB http://www.sqlservercentral.com/Forums/Topic1120768-338-1.aspx provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".The same error occurs when we use Opendatasource (with the correct syntax for opendatasource) instead of Openrowset.We’re not too sure on why this has stopped working, the source file has not been changed in any way and the file is on the same server as SQL SERVER. Also files that were working previously no longer work as well.We have applied the latest service pack 4 to sql server 2005, and even tried restarting the server and the MSSQL Service.Any Help appreciated. Post #1120768 Orlando ColamatteoOrlando Colamatteo Posted Tuesday, June 7, 2011 9:35 AM SSCertifiable Group: General Forum Members Last Login: Thursday, September 29, 2016 1:42 PM Points: 7,932, Visits: 14,336 Might as well move to the latest ACE provider:http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=enSample query:SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\sample_file.xlsx;', 'SELECT * FROM [Sheet1$]') ; _
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91439 ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Express Edition and Compact Edition (2005) Could not find installable ISAM Reply to Topic Printer Friendly Author Topic bodjo Starting Member 8 Posts Posted-10/23/2007: 07:12:13 could not I'm new here and this is my first post. I am not sure if this is the right place for me to post this problem but I really need your help guys. I've been looking for a solution of this problem for almost a week now. I'd googled a lot but of no result.What I want to do is to import records from access 2000 could not find database to SQL 2005 Express. I use the following statement to import records:SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:\Samples\Mydatabase.mdb";User ID=Admin;JET OLEDB:Database Password=mypass', 'tblTab1')The following error shows:Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".I dont know if the statement is correct or I am missing something. I had reinstalled my MS Access but this does not help either. By the way I'm using Access 2003 and my database is 2000 access version.Hope somebody can help me get out of this.thanks,bodjo SwePeso Patron Saint of Lost Yaks Sweden 30421 Posts Posted-10/23/2007: 08:21:03 You need to install JET (sp 8) on the machine running SQL Server.E 12°55'05.25"N 56°04'39.16" bodjo Starting Member 8 Posts Posted-10/23/2007: 21:17:03 I'm using Windows XP SP2. When I tried to install the JET 4.0 SP 8, I received as message stating that I am using the latest version of JET so I do not need to update it. I used WindowsXP-KB829558-x86-ENU.exe from http://support.microsoft.com/kb/239114/Thanks for your reply. bodjo Starting Member 8 Posts Posted-10/23/2007: 21:33:47 by the way, here's the complete error message:OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable IS