Azure逻辑应用程序将Excel内容加载到SQL数据库中 [英] Azure logic app load excel content into sql db

问题描述

我正在尝试将excel内容加载到sql db中，例如将一个excel文件(只有一张纸)映射到sql db中的表.我发现一些文章是关于csv到sql db的.不知道我是否必须先将excel转换为csv或可以在逻辑应用程序中做到这一点?或者 有什么方法可以直接在Logic应用中将Excel从excel转换为sql db?如果我必须将excel转换为csv，请提出建议，如果可能的话，该如何在逻辑应用程序中完成?

I am trying to load excel contents into sql db such as one excel file (with only one sheet) is mapped to a table in sql db. I found some articles were about csv to sql db. Not sure if I have to convert excel to csv first or can do that in logic app ? or is there some way to from excel to sql db directly in Logic app? If I have to convert excel to csv then please suggest how it can be done in logic app if possible?

推荐答案

"https://docs.microsoft.com/zh-cn/azure/connectors/connectors-create-api-excel" target ="_ blank"> Excel 连接器可用于执行此操作.

You can use the Excel connectors available to do this.

请注意，您将需要使用 Excel Tables 来查询excel文件中的数据.

Note that you will need to use Excel Tables to query data from your excel files.

这篇关于Azure逻辑应用程序将Excel内容加载到SQL数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！