Import from Excel file request

Is there a more straightforward way to import from an Excel file than to export Excel to CSV?

If there's not a better way, then one additional feature that would help me is adding Excel to the import file type.

I get a lot of data sent to me in an Excel file, often with multiple worksheets.  While it's not hard to put them in a CSV type file, it is time consuming, so I'd like to put in a vote for adding import from Excel.

Thanks!
Alan Edwards

评论操作 固定链接

Hi Alan, via PowerShell scripting might be an option? I'm not sure if scripting can be incorporated in DG but tailoring a pwsh script for your needs saves you time (and is fun). 

https://www.mssqltips.com/sqlservertip/6561/import-excel-data-to-sql-server-with-powershell/ 

0
评论操作 固定链接

csv export/import is the only option. 

Please create feature request to support xlsx file import at https://youtrack.jetbrains.com/newIssue?project=DBE

0

请先登录再写评论。