Hi Christine. Others here will probably have a more sophisticated method but what you outlined for Access is exactly what I would do. /g -----Original Message----- From: McDonald, Christine, Ms, DCAA [mailto:Christine.McDonald@xxxxxxxx] Sent: Monday, October 20, 2003 3:59 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Excel or Access? I'm working on a project where I need to automate a process.=20 I can do it in either Excel or Access, but am wondering which would be more efficient? Here's what needs to be done: Download an Excel file from Internet. Filter the data using advanced filter (2 separate criteria) Copy the filtered data and append to the end of the cumulative data from previous months. (This is the part I'm stuck on in Excel at this time, how to find the last row of the cumulative data and append)=20 I'm wondering if Access would ultimately be easier and more efficient. What I think would happen in Access would be the following: Download Excel file from internet. Import into Access Run query to filter data. Append filtered data to table of cumulative data in Access Export to Excel file. Any advice would be appreciated. Christine McDonald Technical Specialist Western Regional Office ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to=20 mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************