Cannot export or import sql 2005 1

[Luvsql]

I simply want to import some data into a table or export out data using the import/export window. I have tried both windows authenticated (I am a domain admin) and as "sa" and keep getting the same error on everything. Why is it so difficult now to do this? SQL 2000 was so simple.

The error is "Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.

I've been googling and cannot figure this out. I'm not developing anything, am not using SSIS, I just want to import some data from an excel file into a table.

I have added my domain account in the COM settings on the sql server, but if I try using 'sa' should it skip these credential requirements?

 

[gmmastros]

Take a look at this:

http://social.msdn.microsoft.com/Fo...s/thread/72eec935-0c6d-4542-9e88-19ee7cffc0e4

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Luvsql]

You rock.