SQL Server and MS Access
I need to generate a report. the required information is in Excel sheet.Using this sheet and four tables in the SQL Server database, results should be generated. i am running five queries in sequence to generate the report. this results in creating temporary tables. till now i did this manually by importing the Excel sheet into MS Access database and linking the SQL Server tables to it, but now it need to be automated. can anyone help me how to get the SQL Server tables and the Excel sheet into Access database programmatically using Java.i cannot crreate temporary tables in SQL Server since it is the production server.