Could not find installable ISAM. Export MS Excel

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Could not find installable ISAM. Export MS Excel

Author

Topic

tochaduro
Starting Member

2 Posts

Posted - 2009-01-06 : 14:35:16

I am attempting to export SQL 2005 table to "MS Excel" using the Export Wizard. I get the following message:

Error: Could not find installable ISAM. (Microsoft JET Database Engine)

Additional Information:

OS > Windows XP SP3

SQL 2005 >

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.13
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

-------------------------------------------

These are the steps I followed:

1. Select database (TWO)
2. Select TASKS > Export Data
3. The "Welcome to SQL Server Import and Export Wizard" comes up.
4. Select DB Source "SQL Native Client" and server name.
5. Select Windows Authentication.
6. Destination "Microsoft Excel"
7. Select a path for the Excel file.
8. Once I click next, I get the error message:
"Could not find installable ISAM. (Microsoft JET Database Engine)"

Additional Error information:>

Program Location:

at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.Step2.OnLeavePage(LeavePageEventArgs e)

What have I checked? I thought that perhaps security was an issue.

1. Use Windows Explorer to find the folder on the disk, which contains the database file (.mdb).
2. Right-click on the project folder and select Properties.
3. Uncheck the Read-only property.
4. Click on the Security tab in the properties window.
5. Click Add and find, then select the USERID.
6. Select the Write checkbox in the Allow; column to assign Write permissions to the USER account.

Any ideas?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources