There is an Excel Spreadsheet containing data, residing in an internet site.
It’s very easy to Import data from a local Excel Spreadsheet into SQL Server Database Table using DTS.
But in my case the Excel spreadsheet resides an internet site which has a static name (Example xyz.xls) but varying data inside it.
The spreadsheet contains three columns a, b, c and data below it.
Only data get updated weekly
So basically I have to automate the process of
1. Download Excel Spreadsheet from internet to a local drive (Replace the file static.xls if it already exists)
2. Use DTS to upload the data into SQL Server Database Table
Please reply if there is solution for this or if there are some other ways to Import data from an Excel Spreadsheet residing in Internet into SQL Server Database Table
It’s very easy to Import data from a local Excel Spreadsheet into SQL Server Database Table using DTS.
But in my case the Excel spreadsheet resides an internet site which has a static name (Example xyz.xls) but varying data inside it.
The spreadsheet contains three columns a, b, c and data below it.
Only data get updated weekly
So basically I have to automate the process of
1. Download Excel Spreadsheet from internet to a local drive (Replace the file static.xls if it already exists)
2. Use DTS to upload the data into SQL Server Database Table
Please reply if there is solution for this or if there are some other ways to Import data from an Excel Spreadsheet residing in Internet into SQL Server Database Table