Import from text file is a file instruction that allows to import data from text file into the MS Access table. Instruction offers to import data which are separated by comma, tab or other custom delimiter. There are two instructions that allow to import data from text or CSV file into the MS Access table – (1) Import from text file in Access group and (2) Export to Access in Text group.
1. From the left on the screen, expand your folder and open a process.
2. From the tool bar on the top of the screen, click on Design mode button to go in to edit mode.
3. Click on file manipulation step to open the step.
4. Click on Click here to select an instruction to open the file instruction selector. This will open small dialog that will allow to select the file instruction from the different group.
5. Click on Access group to expand the group and click on Import from text file instruction to select it.
6. Click on Link button on the source side to link the text or CSV file type. This file should contain at least one row of data separated by comma, tab or other custom delimiter.
7. Click on Link button on the target side to link the MS Access database file that contains table.
8. Click on drop down list of table name and select a table where you like to import data from the text file.
9. There are 3 options when importing data from text or CSV file into the MS Access table.
Source contains headings? – Tick this check box if selected source text or csv file contains columns heading row.
Recreate table structure? – Tick this check box, if you want to recreate the target access table structure. This option is helpful when data in selected text or CSV file is different than target table structure and it is easy way to create the access table based on the data in source file.
Clear old data? – Tick this check box if selected target table should be cleared before importing the new data. Instruction will import data at the end of the existing data in the table – if this option is not ticked.
10. Choose the appropriate delimiter that is used to separate the column data in the selected source text or csv file. If data is separated using custom delimiter then choose Custom option and type in the custom delimiter.
11. Click on Save button to save the configured step detail.
12. Click on Run button to run the step. Running this step will import data into the target MS Access table.
The completely configured instruction should look as shown in below image.