Hi all,
I'm having a problem with one of my DTS jobs. Basically it runs a query and exports the results to an Excel template I have created for the report.
The DTS works fine, but in my resulting excel workbook, numeric fields are being formatted as text, even though they're clearly numeric fields. I've pre-formatted the template setting everything to numeric, and it still doesn't work.
Anybody have any ideas why the template formatting isn't taking effect to the data being exported into it?
Any help would be greatly appreciated!
Thanks in advance,
Yazster
I'm having a problem with one of my DTS jobs. Basically it runs a query and exports the results to an Excel template I have created for the report.
The DTS works fine, but in my resulting excel workbook, numeric fields are being formatted as text, even though they're clearly numeric fields. I've pre-formatted the template setting everything to numeric, and it still doesn't work.
Anybody have any ideas why the template formatting isn't taking effect to the data being exported into it?
Any help would be greatly appreciated!
Thanks in advance,
Yazster