Edit an Excel file in MS FlexGrid Before Importing into SQL server
Category:
DatabaseType:
SnippetsDifficulty:
AdvancedAuthor:
Vivek NigamVersion 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