[mso] Excel or Access?
- From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 20 Oct 2003 14:58:56 -0500
I'm working on a project where I need to automate a process.
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)
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
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
*************************************************************
Other related posts:
