aarondewberry
IS-IT--Management
I have a linked excel sheet 'xlAgentsStats' in my database. I regularly append data from my database into this sheet.
However the sheet is part of a workbook template. So each time an append takes place the workbook will be saved as another name and the data will be deleted from the template, to keep it clear.
Heres the problem.....
One of the fields shows the NumberOfDays. This field defaults to text, leaving the user not being able to sum the column in excel. When I linked the sheet originally, I had data in the field. So it defaulted to Number. But when the data is deleted and the template saved, the data type changes to Text.
Is there a way of locking the data type to what it was when it was linked?
Or do it have to go down the non linked route of OutputTo??
Many thanks
However the sheet is part of a workbook template. So each time an append takes place the workbook will be saved as another name and the data will be deleted from the template, to keep it clear.
Heres the problem.....
One of the fields shows the NumberOfDays. This field defaults to text, leaving the user not being able to sum the column in excel. When I linked the sheet originally, I had data in the field. So it defaulted to Number. But when the data is deleted and the template saved, the data type changes to Text.
Is there a way of locking the data type to what it was when it was linked?
Or do it have to go down the non linked route of OutputTo??
Many thanks
