K
Kevin Payne
Hello,
I have an intranet application written in asp using access as the backend
database. My users have requested they be able to download certain data into
an excel spreadsheet. I have limited asp experience and could use some help.
Ideally, the user would be prompted to save and name the file (save as
dialogue) and then the data would be selected and saved into that file. I
know I can use a select statement to select data directly into an excel
spreadsheet using:
SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable
But I'm not sure that is the right approach. Any pointers in the right
direction greatly appreciated...
Thanks,
Kevin
I have an intranet application written in asp using access as the backend
database. My users have requested they be able to download certain data into
an excel spreadsheet. I have limited asp experience and could use some help.
Ideally, the user would be prompted to save and name the file (save as
dialogue) and then the data would be selected and saved into that file. I
know I can use a select statement to select data directly into an excel
spreadsheet using:
SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable
But I'm not sure that is the right approach. Any pointers in the right
direction greatly appreciated...
Thanks,
Kevin