- The third stage is to match the existing table columns with your CSV file columns to confirm all the columns are matched with one another.
- The wizard will let you preview both your CSV file and selected table. Click 'View All Columns' to compare details from both popup windows.
- Check option 'Import first record line from CSV file' to import the first line of your column list header into your database. This line normally consists of columns names.
- There are 3 options to choose from whether you wish to 'Append as new record', 'Replace all existing records' or 'Update records using Primary Key'
- Choose 'Append as new record' to add records directly into the database, and check option 'Use auto increment value for Column' to enable auto increment for selected column.
- Choose 'Replace all existing records' to remove all existing data in your table and replace with new data.
- Choose 'Update records using Primary Key' and select a columns that you wish to update because it will recognize column bearing with primary key to do the data update. Click 'Next' to proceed to the last step.
|
