Transfer Spreadsheet problem

[Peps]

Hi,

I have a small problem, I want to import data into a table from Excel2000. Each time I try, either via code or via a macro, I always get the error.

Couldn't find installable ISAM. (Error 3170)

I'm using Access97, the stange thing is that Access2000 dosent give me any problems.

I reckon it's a refrenence problem, but that's as far as I can go.

Has anyone had a similar problem, or does anyone know how to solve this problem?

Thanks, Peps

 

[Ed2020]

Sounds to me like an Access 97 reinstall is in order......

Ed.

Please do not feed the trolls.....

 

[Peps]

Hi Ed,

I've just reinstalled Access 97 without any luck, I'm still getting the same error. It's without doubt a reference or DLL problem.

Any ideas would be appreciated.

Thanks
Peps

 

[Ed2020]

Have a look at this:

http://www.mvps.org/access/bugs/bugs0017.htm

Please do not feed the trolls.....

 

[Peps]

Thanks Ed,

I've just come from:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;155666

Which basically explains the same as your link.

It's working a treat.
Thanks
Peps