Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wrathyimp
Starting Member
14 Posts |
 Posted - 2012-05-07 : 07:55:52
|
| Hi, I am importing external data from a website to excel.And further importing the excel sheet to SQL tables.But I am not able to update the data from Excel.My DTS jobs are scheduled to run every 1 minute.But for my excels to be updated, I have to make the sheet open and active, so my excel refreshes the data. (also every 1 minute).When the excel is open, its not saved, and the SQL table will not update.So how can i update my sql table with open excel sheets.Thanks for reading it. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-07 : 19:48:17
|
| you cant do update from open excel. Why not include logic inside package to take a copy of excel and paste it in different folder and work with that whilst it gets refreshed?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
wrathyimp
Starting Member
14 Posts |
Posted - 2012-05-08 : 01:31:23
|
| Thanks for the reply,Can you elaborate, your suggestion, How can i copy the excel data to a different file, after each refresh.Actually, I need to fetch tables from a stock market website, tables like top gainers/losers etc.Get the data from the website page to my sql table.Awaiting your reply. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 12:29:14
|
| you can use filesystem task for copying file. create a file connection to excel file and then use copyfile as operation type. You can even make connection dynamic by using expression builder in case excel name changes at runtime------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
wrathyimp
Starting Member
14 Posts |
Posted - 2012-05-10 : 04:29:28
|
| Thanks for replying Visak, Sorry but I am new to this, so i cant catch your comments.How can I do you suggestions. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Update SQL table with data imported from Excel