On Wed, 19 Mar 2008 07:13:54 -0700 (PDT), "
wrote:


However, I did notices that it mentions SQL, I do I need any kind of
MySQL server running or anything? I was hoping to just use excel
files and access files with no special server software running.


No you don't need any other software than what you have. Access is the
front end for a Jet database. It could be the front end for SQLServer,
MySQL, or just about any other kind of database, but if you create the
database in Access (rather than link to it in Access), then you'll get a Jet
database.

You need Jet (installed with Access so you have it), Excel, and ADO. I'm
not sure how ADO gets installed, but I'm sure you have it. It may get
installed with Windows, Office, or both.

ADO lets you work with a lot of different databases using the same syntax.
You'll need to know some basic SQL (structured query language) to tell ADO
what records to return. If you don't know SQL syntax, you can open up
Access, design you're query, and look at the SQL view.

Post back after you've looked at the article if you have any more questions
or need more clarification on anything.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com