Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Get Data from Excel
I can get the data from the spreadsheet into SQL Server. My problem is that before the DTS runs, I need to refresh the web query in the spreadsheet and then save it. How can I do this automatically?- veebster
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Get Data from Excel
I am pulling data from a web page using Excel 2000 and the Web query feature (Basicaly puts the contents of a HTML table in an Excel Workbook). I would like to put this information into SQL Server on a scheduled basis. Whats the best way to do this. Can you do Web Queries straight from SQL...- veebster
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
