By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,619 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,619 IT Pros & Developers. It's quick & easy.

Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table

P: 17
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
Feb 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.