Getting workbooks from a sql server

[atray04]

I have finished my macro that takes workbooks of data and compiles it into a single workbook. My next step is to do this, but take the data off of the local intranet, on a sql server. When I go to the page on the intranet it has a form once I fill out the necessary fields I can get my excel workbook. This needs to be done automated. Here are my ideas on how I think this should be done.
Ideas:
1. have a web link opening it through vb and somehow automatically filling out the fields and going to the necessary pages to get the workbooks.
<if possible>
2. Use SQL code in VBA to login and get the data off.
<if possible>

3. Have someone manually go to the web pages and get the data off
<this is what is currently happening>

My first 2 ideas I am not sure on how to do. I think that idea 2 is what needs to be done, but I have never messed with SQL before so I would need to familiarize myself with SQL first.
If this sounds possible please let me know. Thank you

 

[eramgarden]

So, you have the data in excel book and u want to access the excel doc??

This is what I did: I have the information outputed to a table, then table is outputed to an excel and excel is put on a shared drive for people to access. All done via stored procedures and DTS. I run this every morning

Is the data they enter into the form fixed data? is it like userid and password?

 

[atray04]

no, the data is on the sql database and when i go to the website and type in the information like date range then I get the information which I can choose to view in a excel sheet. Now this data I import into a single workbook. I would rather have this done via autiomation.