Consolidation of multiple data sources

[leimst]

Hi,
I have always been an Excel guy and have never used Access until just
recently when a friend showed my how to use it to identify duplicates in
some very large spreadsheets I was working on. Now having seen just a small
sampling of what Access can do, I was wondering what other applications it
would be suited for.

So here's the question. I have a spreadsheet that I am populating, a
dashboard of sorts, and the data to populate it is coming from 3 other
spreadsheets and an .html documents as well. On a monthly basis, I am
collecting these spreadsheets and the .html document, manipulating and
bringing the data into the consolidated spreedsheet. Would Access be a
preferred method to consolidate this information and maybe even put some
automation around the process?

Thanks for any help in advance,

Brian

 

[Steve]

Hi Brian,

You say you are working with the Excel data on a monthly basis. The answer
to your quwstion depends on what you do with the previous month's data. It
you discard it then sticking with Excel is probably best since you have
Excel experience and have the experience working with your data. Excel has a
rich library of functions and visual basic code that could probably automate
everything you are doing and make the whole process very easy. If you need
to keep previous months' data for month-to-month or other periodic anaysis ,
then Access is the appropriate tool. Access also has a rich library of
functions and visual basic code that could probably automate everything you
are doing and make the whole process very easy.

I provide help help with both Access and Excel applications for a very
modest fee. I have automated many Excel processes and have converted many
Excel processes to Access.

Steve
(e-mail address removed)

 

[John... Visio MVP]

Hi Brian,

I provide help help with both Access and Excel applications for a very
modest fee. I have automated many Excel processes and have converted many
Excel processes to Access.

Steve
(e-mail address removed)

Okay class, all together:

These newsgroups are provided by Microsoft for FREE peer to peer support.
stevie is a known troll who does not understand the word FREE and is only
here to con unsuspecting posters into paying him for software of
questionable value.

stevie, how come you have stopped trying to pull this scam in CDMA?

John... Visio MVP

 

[Steve]

Your tracking of all my posts in the newsgroups your malicious persecution
and libelous statements about me have got to come to an end. You are an
embarassment to the standards of what MVP stands for. Your actions are being
documented and a large dollar amount lawsuit is being prepared against you.

 

[Keith Wilby]

Your tracking of all my posts in the newsgroups your malicious persecution
and libelous statements about me have got to come to an end. You are an
embarassment to the standards of what MVP stands for. Your actions are
being documented and a large dollar amount lawsuit is being prepared
against you.

Best of luck with that mate:

http://www.theregister.co.uk/2008/07/29/advfn_libel_eady_mosley/