How to export different report into SAME excel file
- Thread starter rfan
- Start date
- Local time
- Today, 03:45
- Joined
- Feb 28, 2001
- Messages
- 30,499
Yup, double-posted here and twice in reports.
Don't do that.
If nobody answers, your question didn't really make sense. Hope that someone asks you what you really wanted to do. Like, me.
Are you asking to add another worksheet to the file or to append the report to the bottom of the same sheet as another report already exported?
Don't do that.
If nobody answers, your question didn't really make sense. Hope that someone asks you what you really wanted to do. Like, me.
Are you asking to add another worksheet to the file or to append the report to the bottom of the same sheet as another report already exported?
- Local time
- Today, 03:45
- Joined
- Feb 28, 2001
- Messages
- 30,499
OK, that's actually trickier than creating a new sheet.
The catch is that the NORMAL Access "TransferSpreadsheet" routine wants to start at the top of the sheet. It is further complicated by the fact that transferring a REPORT is not the same as transferring a query.
To be honest, I've never seen anyone send a report to a spreadsheet before. All prior cases were to Word-compatible files like .RTF or .TXT formats. Now that the question has been clarified, I'm going to have to step back because I don't know how to do what you requested directly.
There IS such a thing as transferring to a new spreadsheet and then merging the spreadsheets from Excel - but that isn't the question you asked.
The catch is that the NORMAL Access "TransferSpreadsheet" routine wants to start at the top of the sheet. It is further complicated by the fact that transferring a REPORT is not the same as transferring a query.
To be honest, I've never seen anyone send a report to a spreadsheet before. All prior cases were to Word-compatible files like .RTF or .TXT formats. Now that the question has been clarified, I'm going to have to step back because I don't know how to do what you requested directly.
There IS such a thing as transferring to a new spreadsheet and then merging the spreadsheets from Excel - but that isn't the question you asked.
well, is it possible to transfer into one RTF or TXT then?
If not, how does merging of Excel Spreadsheets works?
PS:
What exaclty I want to do is to combine report data (with same named
text box) into one file for my clients, and make this procedure as easy as
possible.
rfan
If not, how does merging of Excel Spreadsheets works?
PS:
What exaclty I want to do is to combine report data (with same named
text box) into one file for my clients, and make this procedure as easy as
possible.
rfan
EdFred
knows enough, dangerous
- Local time
- Today, 04:45
- Joined
- Mar 2, 2007
- Messages
- 131
What if you import the existing Excel sheet into a dummy table, append the records that would go in the report to the dummy table, export the dummy table back to Excel, write over the existing Excel file, and delete the dummy table?
