Access Data To Excel

Hi guys. Access Data To Excel. I have an Access database. It contains 1 table with data. 1 query based on that table. 1 form whose recordsource is the query. We are talking about the same data. I have an Excel file called EXCEL_DATA with field names on top and corresponding to the field names in Access. Exact arrangement from left to right What I want is to be able to click the button on the form and suddenly the data goes to Excel. But using the same Excel workbook over and over again. Meaning always use sheet 1, called DATA, of the EXCEL_DATA excel file to put the data from Access. What to transfer should be based on the query, or form with the underlying query. It should not be based on the table because there will be filters on the query and form. Attached is the Access file and Excel file for you to study and understand better. Any questions, please feel free to ask IMPORTANT NOTE: The solution must not be odbc connection, or linking to the access database from excel, or any linking from/to Access and Excel. The platform must be MS Access, not .NET, not Visual Foxpro, not Sybase, not Oracle, not Powerbuilder, not VB and so on. Thanks. Jean ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Thursday Nov 10, 2005 8:30:20 AM: IMPORTANT NOTE: The solution must not be odbc connection, or linking to the access database from excel, or any linking from/to Access and Excel. The platform must be MS Access, not .NET, not Visual Foxpro, not Sybase, not Oracle, not Powerbuilder, not VB and so on. It must not be done in Access 2003. It must be done in either Access 2000 or Access XP. Please read the specificication. Please contact me and say that you understand this and you are still interested, if you have bid already --- Thanks, Jean ## Platform It must be done in Access 2002 or 2000. This should not be done in Access 2003.