Tuesday, March 27, 2012

Export database over the web?

Hi, i'm not sure if this is possible. I have an SQL Server database and a secure web server. I upload code via FTP but I don't have access to the database.

Users of my system login under various regions and record data based on their region. These users need to be able to download their data only into an Access database where they can run their own adhoc reports.

Is there a way whereby users can click a button on my aspx page that will pass a variable (user region) and allow them to download an access model or the data into an access model.

Thanks in advance for any help.

You could export the report to a csv. And then import the data into access.|||

Hi thanks for the reply.

Would the users be able to invoke this action and download the file. Users need to import the data into an MS Access database that they hold locally.

|||It would require some training on the users side. The users would export the information from the report into a CSV file and save it to their hard drive. You'd then have a form on the access database that would allow them to "upload" the file into access without having to get into the dirty details of importing.

No comments:

Post a Comment