Error Exporting to Excel

Question

Post reply

Error Exporting to Excel

tariquer

Right there with Babe

Points: 761
More actions
July 18, 2005 at 9:16 am

#60853

Hello,

I have a dts package that is exporing a view to an excel spreadsheet.

The issue is that when I run it on my machine through enterprize manager, then it runs fine. but when i run in on the server it gets an error:

Source: Microsoft JET Engine:

Description: Can not find installable ISAM.

Specs on my machine:

Windows 2k pro. I have office 2000, visual studio 6, .NET( with MDAC 2.8) installed.

Server:

Wndows 2k server, Excel 2k, Access 2k, Outlook 2k and all office 2k add-ons from the cd (data access components from the cd. also MDAC 2.8 and JET Engine 2.8.

any suggestions?

thank you very much in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

tariquer Right there with Babe Points: 761 More actions · Answer 1

I just installed .NET on the server and I still get this error.

When I go into the design of the package on the server and look at the Transfer Data Task properties ( DB Conn -->(Transfer Data Task) --> Excel document ) the properties sheet shows up but when I try to go to the Destination (excel document) the error is:

Provider not initialized.

Aftermore digging I found that if I try to do an Export, through the dts import/export wizard, that my machine has MediaCatalogDB OLE DB Provider, MediaCatalogMergedDB OLE DB Provider and MediaCatalogWebDB OLE DB Provider and the Server does not. any idea what these drivers are for?

what could i be missing? ????? ???

also,

From : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319951

I know that I have to have jet 4.0 and mdac 2.5+ instaled on the server.

I hve jet 4.0 w/ sp 8 and mdac 2.8!!!!!

please help. I have wasted 2 days on this 🙁