Need help to import excel data into SQL Server table

alt_tush

Hi Team,

I have a bunch of data in excel file (suppose test.xlsx) with following format

Field1    Field2       Field3     Field4
1            ABC         30           HR
2            DEF         40           ADMIN
3            PQR         50          IT
4            XYZ          60          Finance

I want to upload this data into the SQL server table.

I have already created the table in SQL database with same format.

Can you please provide me the steps how to import this excel into SQL table?

Thank you in advance.

Waiting for your reply.

CharlieS

The Output Data tool in Alteryx will allow you to output data to a SQL Server database. If you have made a connection to this database in  Alteryx before, the Input Data and Output Data tools will connect in a similar fashion. The Output Data tool can be configured to "Append Existing" to add this data to the existing table (overwriting actions are also available). 

Here is a link to the Tool Mastery article on the Output Data tool here on the Community:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Output-Data/ta-p/30023