Export to multiple Excel sheets no field headers

[MaffewW]

my requirement is to export queries to multiple excel sheets without field headers, I thought there would be an option for it though now I'm thinking it cant be done, has anyone else exported to excel without field headers?

Thanks



Matt

Brighton, UK

 

[MaffewW]

Cracked it thanks to a message in another forum. Right click the tranformation and select options. set the first row to import as '1' and it skips the file header. You do though need to specify the last row as well so need to put in a range higher than the max rows you will ever export (my package exports a few hundred rows so I just specify 10000)

Matt

Brighton, UK

 

[MaffewW]

hold fire on my previous post, its still not working, I was testing with an existing csv file by accident. doh. I'll let you know if I get the solution working

Matt

Brighton, UK