var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exporting Data/1st three lines NOT CSV..
I have a specific format that I need to export data to. The first three lines of the document MUST be in the form of:
klg, Eastern Daylight Time,1,1
If I set this up in DTS and do an export, it puts commas after ascii - which I cannot have.
I've also tried using two data sources and exporting twice (hoping to append), however, one just overwrites the other.
Anyone have any ideas??
Thanks in advance,
Is this from a table?
Read the sticky at the top
A couple of ideas...
You can create two text files, one with the headers. Then use the dos copy command to make one file.
copy file1+file2 file3
Another option is to create a temporary staging table. It can have one large varchar column that contains the data. Then export from this table. This option requires a little work.
YOU'RE AWESOME!! I WAS TRYING TO REMEMBER HOW TO DO THIS EARLIER TODAY!! THANKS SO MUCH!!!!!!!
Originally Posted by cascred
Last edited by Krista327; 10-03-05 at 15:01.
Check your PM.