how to load data from excel to redshift?
In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query. Choose the Redshift DSN. Select the option to use Query Wizard to create/edit queries. In the Query Wizard, expand the node for the table you would like to import into your spreadsheet.