trieber = driver.

Have you tried reinstalling MDAC?



--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

All you are doing is creating a brand new DTS package right and importing
data from Excel to SQL Server?

I am thinking the error may be coming from trying to use the Excel driver.

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Allan,
Thank you! The download makes my SQL DTS work! Yes, all
I was trying to do was import an Excel file into SQL, and
it works fine now.

After the download, when I rebooted I got "An error
occurred calling "DllRegisterServer" in "C:\Program
Files\Common Files\System\MSADC\msadco.dll" (HRESULT =
8002801c). But everything seems to work OK, and I haven't
rebooted to see if that error comes up again.

Again, thank you!
Norm Brokaw


[quoted text, click to view]
url=/downloads/list/dataaccess.asp