Hi Pensio,

Thank you for the update. I'm glad the issue is resolved by yourslef. I'm
so proud of you.

Since the column in the EXcel is able to be changed from number type to
text type by ' , Copying data from a query to the excel sheet could be a
solution also.

For example:
bcp "select ''' +'ArticleNumber ' from table_name" queryout
c:\ExcelSheet.xls -f c:\bcp.fmt -T

There is an article to share with you:
bcp Utility:http://msdn.microsoft.com/en-us/library/ms162802.aspx

Hope the above is helpful. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

Hi Pensio,

Thank you for the update. I'm glad the issue is resolved by yourslef. I'm
so proud of you.

Since the column in the EXcel is able to be changed from number type to
text type by ' , Copying data from a query to the excel sheet could be a
solution also.

For example:
bcp "select ''' +'ArticleNumber ' from table_name" queryout
c:\ExcelSheet.xls -f c:\bcp.fmt -T

There is an article to share with you:
bcp Utility:http://msdn.microsoft.com/en-us/library/ms162802.aspx

Hope the above is helpful. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

Hi Pensio,

Thank you for the update. I'm glad the issue is resolved by yourslef. I'm
so proud of you.

Since the column in the EXcel is able to be changed from number type to
text type by ' , Copying data from a query to the excel sheet could be a
solution also.

For example:
bcp "select ''' +'ArticleNumber ' from table_name" queryout
c:\ExcelSheet.xls -f c:\bcp.fmt -T

There is an article to share with you:
bcp Utility:http://msdn.microsoft.com/en-us/library/ms162802.aspx

Hope the above is helpful. Thanks

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==