Ritu

Ritu

  • 1.4k
  • 347
  • 42.3k

Read excel file from aws s3 and store data in sql table

Aug 3 2022 11:42 AM

Hi
I have excel file which store in S3 bucket, My requirement is read data from excel file and send data to

sql table.While reading from excel file ignore Row 1 i.e title "Employee_Report"

Employee_Report
S.No START_DATE LAST_NAME FIRST_NAME EFFECTIVE_START_DATE ACTION_CODE ASSIGNMENT_STATUS_TYPE_CODE MANAGER_PERSON_NUMBER  
1 2022/05/12 x y 2022/05/12 HIRE aa fgh  
KPMG007 2022/05/17 x y 2022/05/12 HIRE aa fgh  
KPMG020 2022/05/17 x y 2022/05/12 HIRE aa fgh  

TIA.