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 not
Aim- 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 Assignment
Fields:ParentID – Column A
,Rm_Account –Column D
Mapping
Sql Table = Excel Table
MerchantID = ParentID
RMID = Rm_Account
When 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
Regards
D
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Update SQL From excel