Forum Discussion

fabiolamelo's avatar
fabiolamelo
Helper II
5 years ago
Solved

SQL CONNECTION - EXCEL FILE

Hi everyone,   I`m working in one project that a company provide a finance erp service for many clients.   To get the data from their client`s erp they use an API that connected with their client...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi fabiolamelo ,

 

According to your description, I think get a excel file from a SQL server connector is feasible. You can import data from Excel or export data to Excel with SSIS by using one of the following tools:
     1.SQL Server Integration Services (SSIS)
     2.SQL Server Import and Export Wizard

 

related document link:

Import from Excel or export to Excel with SSIS - SQL Server Integration Services (SSIS) | Microsoft Docs

Connect to an Excel Data Source (SQL Server Import and Export Wizard) - SQL Server Integration Services (SSIS) | Microsoft Docs


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.