In this example, I placed column breaks on either side of the vertical separators. This will place them in their own fields, which I can then delete inside Access. If I didn't do this, these vertical separators would become part of the data, and we don't want that. The window contains instructions on how to create, delete, or move these column breaks. The next selection has to do with with where your imported data will be stored.
Access needs to have it in a table.
You have two choices, to create a new table, or to import your data into an existing table. If you are attempting to import your data into an existing table, make sure your existing table has exactly the same fields as the data you are trying to import. If you are in doubt, create a new table with the data. Remember, Access is a relational data base, which means, among other things, that it can pull data from multiple tables simultaneously. So you do not need to worry about having data divided into several tables.