August 8, 2008 at 3:06 pm
hi i got a excel file which i just need to import to sql server DB so the problem here is i will be getting the data from date 08/01/08 to 08/08/08 ....i will import it i dont have any problem in doing that but the next time after couple of days i get the data from date 08/01/08 to 08/15/08 so i just need to import the latest data from 08/09/08 to 08/15/08 so how can i do that please let me know its a bit urgent thanks....
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
August 8, 2008 at 4:09 pm
From your post, it seems that you are doing an incremental load from excel to database.
What I suggest is cerate one lookup table and just stored the last successful load dates.
T_LOOKUP_LOAD_DATES
START_DATE, END_DATE
You can use following steps to update this table
1) Very 1st time insert START_DATE and END_DATE
2) Load Data for this duration
3) After successful Load: Update Start_DATE = END_DATE
4) For Next Run : UPDATE END_DATE = (8/15/2008)
Use these steps so that everytime you will have these dates for increamental load.
Let me know if this helps :
😉
August 10, 2008 at 5:21 pm
Sarang has some good advice. You want to determine which files are uploaded and which ones are not, and then programmatically handle the import.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply