July 31, 2009 at 9:00 am
Hi
I have a excel file with 3 sheets(Sheet1,Sheet2,Sheet3).Sheet1 contains basic data like dimension values like (ProductName,ProcuctType,Month) that i can load directly into the Table. Now coming to Sheet2 contains some Fact data and i need to update that fact data fileds into the same table based on ProductName,ProcuctType,Month and Sheet3 also contain some more fact data and that also need to be updated into the same table based on ProductName,ProcuctType,Month
Overall here we need one INSERT query and 2 Update Queries based on some contion
so can any one help regarding how to proceed with this requirement??
Thanks in advance
July 31, 2009 at 9:30 am
you need to create stage tables in sql database only, and first populate the data in those tables and then finallly load it in excel sheet.
July 18, 2014 at 7:08 am
Hi,
Here the question is to update data in the table from excel.
After creating stage tables , how to update that data into main table. Can you answer more briefly with query.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply