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 |
|
masond
Constraint Violating Yak Guru
447 Posts |
 Posted - 2013-10-23 : 11:08:56
|
| Hey Guys Hope your well Not sure if i am in the correct forum or notAim- update a table in SQL from excel Sql Table : [FDMS].[dbo].[Master_RM_Account_List]Fields:[RM_Key],[MerchantID],[RMID],[Include],[RM_Added],[Start_Date],[End_Date],[RM_Name],[Area],[Active]Excel File Name : RM AssignmentFields:ParentID – Column A,Rm_Account –Column DMapping Sql Table = Excel TableMerchantID = ParentIDRMID = Rm_AccountWhen ParentId is assigned a Rm_account code (in the excel document), i want to populated SQL table (field :RM_Added) with the last day of the given month. For eg if a parrentid was assigned today 23/10/13 i want the date format to be 2013-10-31. I want the Start_Date Populated with the beginning of the month eg ‘2013-05-01’ (This calculation needs to be from the date the RM_account was assigned.I need this to be via a windows authentication I am hoping you can help RegardsD |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Update SQL From excel