Viewing 5 posts - 46 through 50 (of 50 total)
I don't know whether you call it trying?? I appreciate you help.
Below is where I have started. Where am I going wrong. Do you think if I...
November 29, 2011 at 8:29 am
Sorry to be so slow. Who would you create a format file from a current tab delimited file?
November 29, 2011 at 8:09 am
exec master..xp_cmdshell 'bcp "SELECT[RecordType],[CustomerGroupFROM [HBSLIVE].[dbo].[UDEF_WEB_UPDATE_RASS_ASR]" queryout "D:\WebFiles\Web Update File Out\*** Update Files\RASS_ASR_ALL.xls" -f "D:\WebFiles\Web Update File Out\Format Files\mytestformatfile.fmt -UKYLE -User Name -SAppserver'
If I have a text file in the...
November 29, 2011 at 5:36 am
Yes I did but I could not work out how it all went together.
Do you create a note file .fmt. From the bcp do you then put -f path\format...
November 29, 2011 at 5:19 am
Where do you put the format file. What type of file is it?
November 29, 2011 at 5:10 am
Viewing 5 posts - 46 through 50 (of 50 total)