This process can be done by inserting all of this information into one existing or new database. However, these procedures are performed for the purpose of store all or part of the data contained in a text file in a Microsoft Access database. When the procedure is done, you have the option to select the objects you want link or import, in this way you can control how tables and queries will be transferred and in the same way indicate whether there are relationships between tables. When these types of imports de data, Access intended to create a copy of the data in the database of destination without having to change the source. What are the most important things to consider before linking data from a text file to Access? If the actual length values vary from one recording to another, these values will not reach not the required width to be completed with trailing spaces. The first field of registration will always have seven characters, to the second record, the length will always be 12 characters, and so on for the other records. To better understand this, an example would be: The fixed width files are those where each record appears on a separate line width of each field remains uniform across all registers.

Note that this can be any character that does not appear in field values, as: point - comma ( ), space, tab, comma (,), period (.), Among others. The delimited files are the place where each of recordings appears on a different line and fields are separated by a single character, this is called a delimiter. So that you can understand this a bit more, here we explain each of them: Delimited files

Excel text import wizard fixed width