Exporting to Excel

[DennisM3]

I'm trying to export a table to Excel using SQL's Server DTS wizard, when I click finish I get the following pop up window that reads:"Failed to copy 1 table(s). Double click on the error row for a detailed description of the error."

So when I double click on the error, I get the following:"Column name 'IPMP1.PREV.DTOT' was not found".

Any clues anyone?? Thanks!

 

[JayKusch]

Is 'IPMP1.PREV.DTOT' a field within the table you are trying to export?

Thanks

J. Kusch

 

[DennisM3]

Yes it is. Is a column on my table.

 

[JayKusch]

Are there any other field names that have the "." as a seperator?

Thanks

J. Kusch

 

[DennisM3]

Yes there are other columns named with "." as a separator (all of them actually).

 

[DennisM3]

J !! It is the fact that the export utility DOES NOT LIKE THE "." separator!! I'm going to have to change all my names and eliminate the "." Thank you sooo much!!!

A very Happy man,
Dennis

 

[JayKusch]

Interesting ... I am wondering if DTS is trying to translate the field name into a fully qualified name. That beinging [DatabaseName].[TableName].[FieldName].

Is 'IPMP1.PREV.DTOT' the first field of your table? If so, can we temporarily rename it so test1, run your DTS export again and check the error message to see if it fails on the field name directly after the renamed "test1" field.

Thanks

J. Kusch

 

[JayKusch]

EXCELLENT ... sorry for the late post. please disreguard since we have tracked down the issue. Have a great weekend!

Thanks

J. Kusch