Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help to import excel data into SQL Server table

alt_tush
9 - Comet

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.

6 REPLIES 6
LordNeilLord
15 - Aurora

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
9 - Comet

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
15 - Aurora

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"

 

SQL Append.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

alt_tush
9 - Comet

Thanks Neil :)

BIChickie
5 - Atom

Thanks so much! this is helpful 

prince19
5 - Atom

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?

Labels