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

3 comments
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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.

0

Please sign in to leave a comment.