Hi,
I have created a table using vbscript and an ADO connection to an Access Database. some of the tables are large and I would like to give the user the opportunity to download the file to excel.
The way I had envisaged of doing this was to fire off an access macro or a VBA function in Access that would export the table to a specific address and then return a page with the address of that exported file.
Unfortunatley I have no idea how to get Access to run non-SQL stuff from an ASP page.
can anyone help me?
Kind regards
Paul
I have created a table using vbscript and an ADO connection to an Access Database. some of the tables are large and I would like to give the user the opportunity to download the file to excel.
The way I had envisaged of doing this was to fire off an access macro or a VBA function in Access that would export the table to a specific address and then return a page with the address of that exported file.
Unfortunatley I have no idea how to get Access to run non-SQL stuff from an ASP page.
can anyone help me?
Kind regards
Paul
