将excel文件从Sharepoint上载到Azure SQL DB [英] Uploading excel file from Sharepoint to Azure SQL DB
问题描述
你好,
我有一个任务,基本上需要创建无服务器服务(所以最好是某种功能/逻辑应用程序)来上传存储在Sharepoint中的excel文件到Azure SQL数据库。我正在考虑的内容草图 - Sharepoint-> Blob存储 - >将
XLSX转换为CSV-> ADF-> SQL DB。但是,这是一个很好的解决方法,因为我还没有找到一个解决方案,要将excel文件从Sharepoint上传到$ DB $ b 。您对更优雅且可能更简单的解决方案有什么建议吗?
I have a task, which basically requires to create serverless service (so preferably some kind of Function/Logic App) to upload excel file stored in Sharepoint online to Azure SQL Database. Sketch of what I was thinking about- Sharepoint->Blob Storage->Converting XLSX to CSV-> ADF->SQL DB. However, it's quite a workaround, as I haven't find a solution for excel file to be uploaded directly from Sharepoint to SQL DB. Have you got any suggestions for more 'elegant' and possibly simpler solutions?
推荐答案
查看此链接是否可以帮助您
See if this link helps you
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-load-from-csv-with-bcp
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-load-from-csv-with-bcp
这篇关于将excel文件从Sharepoint上载到Azure SQL DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!