Navicat provides a user-friendly way to import fixed length data.
In this tutorial, we will show you how to import a text file with fixed length data.
To begin, start an import wizard in Navicat and select the source text file.
You will need to define the data delimiter in step 3.
Select the “Fixed Width” option and you can preview data in the wizard immediately.
Then, you can delimit the source column bounds on the wizard directly. Click on the desired position to create a break line on it.
To move the break line to your preferred location, you can simply drag the break line.
Or, you can just double-click the break line to have it removed.
After that, you can continue with the wizard and click the “Start” button in the last step.
Now, you can open the imported table in Navicat.
