Edit an Excel file in MS FlexGrid Before Importing into SQL server

Category:
Database
Type:
Snippets
Difficulty:
Advanced
Author:
Vivek Nigam

Version Compatibility: Visual Basic 6, Visual Basic 5

More information:
Import and edit an Excel file in a MS FlexGrid control before Importing the Data into SQL server. Step 1: User Can Select Excel sheet, the data from Excel will be displayed in list format. Step 2: User can edit and modify the details, which he selected. Step 3: User can also import data into a SQL Server database. There are lot more options available which can be used after some modifications to the code, e.g. mapping and importing data into the original table by selecting a column's name.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download import_excel_file.zip