Edit an Excel file in MS FlexGrid Before Importing into SQL server
Version Compatibility: Visual Basic 6, Visual Basic 5
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.