ActiveX component can't create object.
Hi guys..
I have problem with exporting excel file to access..
it only happens when machine has access 2000, excel 2000.
with access 97 and 2000 doesn't prodce this problem..
so i am thinking there's some active X component missing between 97 and 2000...

my code is

sungaccess.Docmd.transferspreadsheet acimport, acspreadsheettypeexcel97...etc..

i don't know where to start to find the problem..
will you help me please..thanks..