February 20, 2007 at 1:14 am
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 in 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
February 20, 2007 at 2:13 am
you can develop your own application in the following way:
Method: 1
-> Develop an application using C#.NET, VB.NET, VB 6.0
-> Design the GUI as per your requirements and download the file using avaiable API calls.
-> Open the Excel file and read the data, and trafer the data to destination server.
(Note: Required authorization to connect servers)
Method: 2
Write the asp code in your web-page and transfer the data.
Try it.
February 20, 2007 at 11:08 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply