Exporting data to Excel -- sql server dts

Yuelin Liang
2/28/2005 10:26:08 PM

Hi

As a test, I was trying to export the pubs database to Excel. There is
always one
table I couldn't export: the pub_info table. Others were OK. The error I got
was:

"The Microsoft Jet database engine could not find the object 'pub_info'.
Make sure the object exists and that you spell its name and path name
correctly"

Could any one tell me why I got this problem?

Many thanks

Yuelin

Sue Hoegemeier
3/1/2005 9:18:51 PM

The error is misleading but it's because it's blob data in
the table. Check the data types for the columns in the
table. You can't do a simple select and export blob data to
an Excel file - which is what a basic export would do. Blobs
are managed differently from other data types.

-Sue

On Mon, 28 Feb 2005 22:26:08 -0000, "Yuelin Liang"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Exporting data to Excel