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.

[LordNeilLord]

Hey @alt_tush

You just need to do it via an output tool using SQL server as your connection. 

Here's a handy video:

[alt_tush]

Hi Neil,

Thanks for sharing video.

I went through same video but it doesn't work for me.

It works if you don't create a table in sql server. If the table is already there and  I want to append the data into the table using excel as input then how I do?

Because I don't find any table selection option in property window where I want to upload the data.

Thank you.

[LordNeilLord · Accepted solution]

Hey @alt_tush

The you can set the table name when you connect to your SQL server with the output tool or you can change it in the output data config screen. To append you need to select "append existing"

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[alt_tush]

Thanks Neil :)

[BIChickie]

Thanks so much! this is helpful 

[prince19]

if you get a new excel next month, how can we append the data to the created table without running the flow manually? is that possible?