Excel Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My company currently has a large amount of data in Excel. We think we would
be better suited to have it in Access. However, we need to be able to import
new data on a monthly basis, while simultaneously maintaining the old data in
a monthly and YTD format. From time to time, new types and new categories of
data present themselves, which is something that we need to be able to
handle, as well. Lastly, this process should be as automated as possible.
We should not have to manually import vast quantities of data, nor should we
have to copy/paste the same data into different sections.

Does this sound possible? Our main motivation is that every month it takes a
day or two for somebody to update all our Excel sheets. Will this process be
quick enough to make us more efficient? In other words, is this worth the
effort?
 
On what basis did your company decide that Access would be a better tool?

"Will this process (?to update all our Excel sheets?) be quick enough...?"
We don't have a very complete description of what you mean by "update" or
"process". On what basis would you like us to guess whether you would be
more efficient?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Wow, I can sure tell why you have the awesome title of Microsoft
Office/Access MVP, a title which seems almost cool/hip enough to make one
think that having it isn't nearly as nerdy as it sounds.

Subtle sarcasm isn't very difficult to come up with, nor is it very
difficult to spot. I will interpret your question "On what basis would you
like us to guess whether you would be more efficient?" as a less polite way
of saying "That's not enough information. Could you perhaps give us more?"
My answer is: "How can I maintain historical data while at the same time
importing new data? What is the best (most efficient) way to import data?"
 
That's quite an attitude for someone who doesn't know how to import data and
so is asking for help!

The MVPs don't get paid for what they do, they give their own time to help
people who quite often don't have a clue what they are doing to get things
done. If you think Jeff was being sarcastic you should post something in a
C++ newsgroup, they have a field day with this stuff.

As to your question, without any kind of handle on what data you deal with
and how much of it you have, I'd say that you would be better storing it in
Access as data storage is its forte.

MH
 
Tony

I wasn't trying to be sarcastic. Sorry if it came across that way. If you
dislike sarcasm, why respond as you did?

I was actually trying to learn what criteria YOU would use to evaluate
"efficiency". You and I may not have the same definition.

It appears you've already decided to "import data". That defines a "how".
There may be other ways to satisfy your business need, but we'd need to know
a bit more about the "what" to offer informed suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top