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
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.
> via PowerShell scripting might be an option? I'm not sure if scripting can be
It's like asking car maker to add windshield wipers and here is genius suggesting
people get hold of some mini-motors and rubber pieces and make your own.