If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export filtered records
Hi,
I am trying to export certain records that have been filtered. When I export it to excel, save the file and then reopen the file all records are displayed in excel. I woul dlike only the records that I have filtered to export from Access to Excel. Any suggestions? Thanks Linda |
#2
|
|||
|
|||
Export filtered records
On Fri, 4 Dec 2009 12:44:01 -0800, linda wrote:
Hi, I am trying to export certain records that have been filtered. When I export it to excel, save the file and then reopen the file all records are displayed in excel. I woul dlike only the records that I have filtered to export from Access to Excel. Any suggestions? Thanks Linda Exporting to Excel what? How? What version of Access? The simplest method to export filtered records is to create a query that contains just the records you want to export. Then export the query data. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "C:\MyFolder\ASpreadsheet.xls", True -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Export filtered records
This is what my form does.
I have an active control (excel sheet). All records are loaded on Open using a query. The user wil then use the filter feature on the excel sheet to filter out their results. From this point on, I would like the user to export the filtered info to Excel again from the active control. Once outputted to Excel, the user must save the file. However, when you go to open the saved file, all records are in the file rather than the filtered output. Linda "fredg" wrote: On Fri, 4 Dec 2009 12:44:01 -0800, linda wrote: Hi, I am trying to export certain records that have been filtered. When I export it to excel, save the file and then reopen the file all records are displayed in excel. I woul dlike only the records that I have filtered to export from Access to Excel. Any suggestions? Thanks Linda Exporting to Excel what? How? What version of Access? The simplest method to export filtered records is to create a query that contains just the records you want to export. Then export the query data. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "C:\MyFolder\ASpreadsheet.xls", True -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail . |
Thread Tools | |
Display Modes | |
|
|