v1.3.0 - CSV Import Support

[1.3.0] - 2026-04-28

Added

• Added CSV import support.
• Added import source type selection for Excel or CSV.
• Added CSV file browsing with .csv file filter.
• Added CSV header loading.
• Added CSV preview loading.
• Added CSV row import using the existing mapping, validation, staging, and final import pipeline.
• Added CSV-aware import logging.
• Added UTF-8 BOM support for CSV import.
• Added automatic CSV delimiter detection for comma, semicolon, and tab-delimited files.
• Closing tool forms with main form
• Safer close behavior during import/export

Changed

• Generalized import source handling so the Import form can process both Excel and CSV files.
• Renamed internal import variables and methods from Excel-specific names to source-based names where appropriate.
• Updated import UI captions based on the selected source type.
• Improved import validation to check file extensions based on the selected source type.

Fixed

• Removed obsolete Excel-only preview and validation paths after adding shared source handling.

Notes

• CSV import uses the same mapping, validation, staging, transaction, logging, progress, and cancel workflow as Excel import.
• CSV files are expected to use the first row as headers.
• CSV import automatically detects common delimiters such as comma, semicolon, and tab.
• CSV files saved as UTF-8 with BOM are supported for Persian and other Unicode text.

v1.2.0 - SQL Export to Excel/CSV

[1.2.0] - 2026-04-27

Added

• Added a new main form (frmMain) to manage shared SQL Server connection, database selection, table selection, and tool launching.
• Added a new Export tool form (frmExportSqlToExcel).
• Added support for exporting one or more SQL Server tables.
• Added checkbox-based table selection for export.
• Added checkbox-based field selection per selected table.
• Added default table selection in Export form based on the table selected in the main form.
• Added table search support in the Export form.
• Added right-click context menu for selecting all or none in table and field lists.
• Added CSV export support.
• Added Excel export support:
  • .xlsx export using Excel Automation when Microsoft Excel is installed.
  • .xls export using ADO/OLEDB when Excel is not installed but the required provider is available.
• Added export output folder selection.
• Added overwrite confirmation for existing output files.
• Added export progress tracking.
• Added export cancel support.

Changed

• Refactored the Import form to use the shared application context from frmMain.
• Moved SQL Server connection, database selection, and table selection responsibilities out of the Import form.
• Improved separation between shared application state and Import-specific workflow.
• Improved Import summary counts so staging and final target import counts are no longer mixed.
• Improved Export UI behavior so field selections are preserved when switching or searching tables.
• Improved Export UI behavior so the Cancel button remains clickable during export.

Fixed

• Fixed incorrect Import success count where staging and target import counts were combined.
• Fixed field selection reset issues when searching and reselecting tables in the Export form.
• Fixed right-click “Select None” behavior for field selection.
• Fixed Export cancel button becoming unavailable during long-running export operations.
• Fixed UI container issue where disabling a parent frame prevented the Cancel button from being clicked.

Notes

• CSV export is the most portable output option and does not require Microsoft Excel.
• Excel .xlsx export requires Microsoft Excel.
• Excel .xls export can work without Microsoft Excel when the required ADO/OLEDB provider is available.

v1.0.0 – First public release

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