I tried that Madhivanan, only that particular Job fails. when I do the DTS and run immediately it succeeds, but when I schedule it, it fails.
Madhivanan, The database is online and I need to create a job to update a table from an excel file which is also available online as I said above...
Thankx for the reply Madhivanan I gave the path as it is but it says cannot open the file, I need to schedule this import every morning around say...
Dear Madhivanan Things are working great, Thankz for your help. I have one question... I am trying to create a DTS or may be I can also create a...
You are a life saver buddy, thanks a lot,that's cool and works GREAT... THANKX AGAIN
Works great Frank, thankx buddy, by the way a question please dont get offended, how do you make this query to insert records until today? LIKE THE...
Thank you Frank, Hope this should work, I will work it out and let you know.
Sure Frank Kalis<br /><br />for eg this is my data (which I already have)<br /><br />EMPNO EMPNAME DATEPUNCH TIMEIN1 TIMEOUT1 TIMEIN2...
Dear Friends Am developing an TimeSheet application, I import data from an excel sheet to a table in the SQL Server and display them to the...
Thankx Madhivanan,letme try this out and get back to you. SHUKRAN.. (Arabic way of saying Thankx)
That's great and a prompt reply Madhivanan, that did help me, Thankx a lot. I have a another question if you think am not bugging you, is it...
Thankx dudes I made it work, used DTS to import data from excel to a dummy table and scheduled a job to dump the data to original table and used a...
Thankx Satya and Madhivanan, Madhivanan I tried ur way it works fine but my concern is about to update only fresh data, guess can give a try to...
Satya I checked the blog but it says how to "Generate an Excel XLS spreadsheet from T-Sql in Sql Server" I need to know the other way around, From...
Thankx for the replies pals, Dear Ranjit Jain, as you said I have the excel sheet with the old data and the newly added data, I cannot delete the...
Hi friends I think DTS is a solution for the problem I have and this is my first project using this technology, Hence I need help from you guys[:I]...
Separate names with a comma.
