[mso] Re: Excel or Access?
- From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 20 Oct 2003 15:36:56 -0500
Thanks for your input. I'm really leaning toward the Access method
simply because I think it would be more efficient in the long run. More
work for me up front, since I know less about VBA in Access than I do
about VBA in Excel and I don't know a lot about VBA in Excel.
Christine McDonald
Technical Specialist
Western Regional Office
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]=20
Sent: Monday, October 20, 2003 1:16 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel or Access?
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.=3D20 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)=3D20
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=3D20
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=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
*************************************************************
Other related posts:
