Skip to content

v1.0.0 – First public release

Choose a tag to compare

View all tags
@fzseyedi fzseyedi released this 24 Apr 14:51
· 9 commits to main since this release
v1.0.0
16178a1

Initial public release of Excel To SQL Import.

This version includes a working VB6 desktop tool for importing Excel data into SQL Server tables with a safer staged workflow.

Included in this release

  • SQL Server connection
    • Windows Authentication
    • SQL Server Authentication
  • Non-system database browsing
  • Base table browsing
  • Database and table search
  • Excel loading with:
    • ADO/OLEDB
    • Excel Automation
  • Excel header loading
  • Excel preview rows
  • Manual column mapping
  • Auto Match
  • Save / Load mapping
  • Required mapping validation
  • Duplicate SQL-field mapping prevention
  • Staging-table based import
  • Final import into target table
  • Transaction support
  • Commit / Rollback handling
  • IDENTITY_INSERT handling
  • Duplicate handling
  • Progress and status tracking
  • Log file generation
  • Improved friendly error handling
  • Cancel during import
  • Optional saving of last connection settings

Notes

This is the first public release and is intended as a practical, working version for controlled/internal usage and further community improvement.

Known direction for future improvements

  • richer final import summary
  • separate row-level error log
  • save more user preferences
  • optional keep-staging-table mode
  • additional UX improvements
Assets 2
Loading