Our SQL server has some tables that we need to pivot (with transact SQL statements) then export to Access. We have some ASP that creats the dynamic SQL to view the results on the web page, so that's not our issue.
Question is: what is the best way to get the resulting data to an Access database via code on the server side? We've hardcoded a DTS package that does it nicely, but the SQL query is currently hardcoded and the nature of the pivot is such that the SQL will change as the data changes. We can't find a Dynamic Property that will allow us to set the SQL from ASP (anyone know what it is?).
Is there a better way to go about this? Users are remote and won't be able to link to the SQL database.
Thanks.
Question is: what is the best way to get the resulting data to an Access database via code on the server side? We've hardcoded a DTS package that does it nicely, but the SQL query is currently hardcoded and the nature of the pivot is such that the SQL will change as the data changes. We can't find a Dynamic Property that will allow us to set the SQL from ASP (anyone know what it is?).
Is there a better way to go about this? Users are remote and won't be able to link to the SQL database.
Thanks.