Unanswered: Exporting query result into excel file
Hi i am newbie . I want to transfer the query result into excel file throgh asp code. can any one help me out.
Also how can i automate my routing task that is data in excel to be updated in the table which is in SQL server. Say x.xls is the daily file maintaned by me and i want y table in sql server to be appended once this file is saved.