I faced the following problem when i do DTS to excel from
my vb program.
"
Copy Data from Results to Results Step failed Microsoft
JET Database Engine The Microsoft Jet database engine
could not find the object 'Results'. Make sure the object
exists and that you spell its name and the path name
correctly."

Anybody know why?...

Forget about the VB program for a minute. Can you execute the package
normally and it works?
DTS from where to Excel?
You have to have a Source object called Results and a destination object
(named range) called Results which according to the error is not true in
this case.


--
--

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


"anna (AT) ccn (DOT) com.sg" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Whenever I've seen this error message in my experience, I've always
discovered ultimately that it's correct -- that I have provided an incorrect
path to the spreadsheet itself, or spreadsheet name, or sheet name, or range
name. Remember that you don't get an error on first opening the connection
even if the path is invalid or the spreadsheet doesn't exist, so check
everything. Make sure you have a named range named Results, or that you use
the $ and delimiters if it's the worksheet name. Best of luck with your
troubleshooting.

-Doug

--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.


"anna (AT) ccn (DOT) com.sg" <anonymous (AT) discussions (DOT) microsoft.com> wrote