Excel files on local machine to SQL server

Arvindkumar — Thu, 05 Nov 2020 03:33:16 GMT

Hi All,

Need help in getting data from Excel files on the local machine to the SQL server.

I have a few excel files on my local machine (can be in a shared location), want to import those files into SQL server (On-prem). or Destination can tableau extract as well.

The workflow works fine on my local machine, but I want to deploy onto the server and schedule a job to run every day.

This should be a simple task(I think) but not able to find any online guide to get this done.

In the power bi, Azure world we use Data gateway to get local/on-prem data.

Do we have something similar for Alteryx? I read somewhere we need to create .bat file with user credentials in the "Events" section.

Can you please help with the steps to get this working?

Regards,

Arvind

Re: Excel files on local machine to SQL server

joshuaburkhow — Thu, 05 Nov 2020 11:59:53 GMT

This is a duplicate post. I've answered here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-files-from-local-machine-to-SQL-server/m-p/661682#M153612

topic Excel files on local machine to SQL server in Alteryx Server Discussions

Excel files on local machine to SQL server

Re: Excel files on local machine to SQL server