paragvshah
Programmer
We require to take a backup of some of our tables in our database on a periodic basis.
We need to take this backup on an Excel spreadsheet. What we require is probably a function that runs a query in the database, picks up all the records that fall in the specified criteria, that is between a specified time period.
This function should then perform a DTS operation, create a new excel spreadsheet and name it and transfer all the records to the spreadsheet.
Is this possible? There must be user intervention in the script. The user will have to be able to specify the time period between which he requires all the data.
What our code is doing is that every time a member signs in all the details are being entered into the profiles table along with the date of registration which will be the system date.
The data that will go into the excel sheet will be used as a backup and can be used as a report.
Please give me the code to do the same.
PARAG
We need to take this backup on an Excel spreadsheet. What we require is probably a function that runs a query in the database, picks up all the records that fall in the specified criteria, that is between a specified time period.
This function should then perform a DTS operation, create a new excel spreadsheet and name it and transfer all the records to the spreadsheet.
Is this possible? There must be user intervention in the script. The user will have to be able to specify the time period between which he requires all the data.
What our code is doing is that every time a member signs in all the details are being entered into the profiles table along with the date of registration which will be the system date.
The data that will go into the excel sheet will be used as a backup and can be used as a report.
Please give me the code to do the same.
PARAG