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.
Solved! Go to Solution.
Hey @alt_tush
You just need to do it via an output tool using SQL server as your connection.
Here's a handy video:
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.
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"
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thanks Neil :)
Thanks so much! this is helpful
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?