MS Access 2003 - Add Sybase Linked table records

Convert MS Access Append Qry to VBA code: requirement to append Sybase linked table data into existing MS Access database table based on date period with count; source Sybase table contains over 40 millions rows; Access Database with append query included in zip file ADDED COMMENT: the target database could be MS SQL Server linked table in case the target output exceeds max size of MS Access 2003 database which is 1GB ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platform Windows XP, MS Access 2003, VBA