Getting workbooks from 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

 

[wmichael]

While I am not entirely familiar with ODBC, I know that Excel can use ODBC to get to SQL. I would suggest going for option #2 before #1.

Good luck!

~wmichael

&quot;small change can often be found under seat cushions&quot;