I have sql server data which i want to export to access everday with out intervention of the user.I scheduled it. But As the database and tables are same, The data is being appended to old one. I want DTS to export the data in seperate tables( may be with different names) or in seperate databases every day to access with out user intervention.

Better if i can suffix date of export to the file/ table.

Any Help

Thankx In advance

R.D.CHETTY

you should dynamically create the table name with the date appended
using activex scripting and then export to access.

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***

Hi Partha

I think u r from AP. Your are doing great work through this

well, I am a novice in ActiveX scripting in SQL . can just tell me where can i get this stuff to understand . Better you can send me a piece of code