Import from Excel file request Follow
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
Please sign in to leave a comment.
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/
csv export/import is the only option.
Please create feature request to support xlsx file import at https://youtrack.jetbrains.com/newIssue?project=DBE
I created a feature request https://youtrack.jetbrains.com/issue/DBE-16794/Import-from-Excel-file-request but it was closed as a duplicate. I guess this has been a long requested feature.