Run-time error 3170 - Couldn't find installable ISAM 1

[WP]

While trying to import an EXCEL spreadsheet I get this 3170 error.<br><br>Code:<br>DoCmd.TransferSpreadsheet acImport, 5, strTableName, strSpreadsheet, True<br><br>I have re-installing the Data Access drivers in Office 97 but no change.<br><br>The help for this error says it ACCESS can't find the DLL for this installable ISAM .<br><br>Has anyone any ideas?<br><br>WP<br> <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[rhicks]

Change the constant &quot;5&quot;. If you are importing an Excel 97 spreadsheet it should be &quot;8&quot;. Use &quot;acSpreadsheetTypeExcel97&quot; to see if that clears the problem up. The code should read:<br><br>DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, strTableName, strSpreadsheet, True<br><br>Maybe this will help,<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[WP]

rhicks,<br><br>No difference.<br><br>WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[rhicks]

Bill do you show the ability to Import and export to Excel from the File menu of Access? Is Excel a choice in the dropdown lists of these actions? If Access or Office has been uninstall on your machine, then re-installed, I have seen problems. Some of the drivers including Excel will be dimmed out during setup. This could give the problem, the dll's may need to be reregistered. Try the solution below to see if this helps.<br><br>(This is from an earlier post of mine)..............<br><br>Possible .dll files that need to be reregistered.<br>1. mstext.dll <br>2. msexcl35.dll<br>3. msxbase.dll<br>4. msltus.dll <br><br>Here is how you reregister the .dll files.<br>First shut down any MS Office programs that are running.<br>From the Desktop, click the Windows Start Button, choose Find, then Files or Folders.<br>Type this for the files to be found&nbsp;&nbsp;(with the commas): <br><br>regsvr32.exe,mstext35.dll,msexcl35.dll,msxbase.dll,msltus35.dll <br><br>Click &quot;Find Now&quot;, this will locate the needed files (you may have more than one regsvr32.exe, but this is OK).<br>Using the window you are viewing, drag and drop each .dll file on top of regsvr32.exe and release it, one at a time. This will reregister each .dll file. You should receive a message say that the registering was successful. After completion you should see these as a choice when you need them.<br><br>This may not be your problem but it's worth a shot.<br><br>Good Luck,<br>RDH<br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[inf33323]

Hi,

which .dlls need to be reregistered if I'm using a ODBC datasource?

Regards,

inf33323

 

[HolyDevil]

Thanks Ricky Hicks I did exactly what u said to register the dll files and I'm able to import again! thanks!