Use of Excel to pull data from database daily, posting new data below older data

Okay. So here's what I am trying to do (obviously ficticious names):

There is a database ("Motherload") that houses some records (29 fields in each record) that is updated on a daily bases (except for weekends, holidays, and the first/last business day of the month). I want to have excel go into this database, pull all of the information in the database and paste it in a single excel spreadsheet (ResourceEater). I will be doing this daily, and I want the information I am pulling to go directly below the information that was pulled the day prior. The rest of it (sorting, etc.) is easy and I can handle that macro. I don't know if I need to go the DAO route, or if there is a simpler way. The problem doesn't seem so difficult, but I the data I am going to attempt to pull is extremely important and if I mess up, my boss will kill me.

I haven't drafted any code yet, and would greatly appreciate any direction you can steer me in.

Hi,

Wich kind of database are you connecting to, good thing to know when you choose method to connect with.

Steffen Thomsen

My apologies. I am pulling this from a Microsoft Access 2003 database. Is that what you were wanting to know?

Hi again,

Then im afraid i cant help, havent worked with acces databases, only mysql.

But i think you should look into the DAO thing.

Steffen Thomsen

Go to Data -> Import and set up a data connection.

http://office.microsoft.com/en-us/ex...001183132.aspx