Maintaining relationships while normalizing the imported data.Getting Access to properly interpret data.In a nutshell, you face two potential problems with every import task:
Even if the import gods favor you and everything goes well, you'll probably need to normalize the imported data - and that means maintaining relationships while dividing the table into separate tables.
The goal is to get Access to import all the data the first time out, if possible. On the other hand, if the import drops hundreds of values, you've got a problem. If you're dealing with only a few records, discerning the missing value and entering it manually isn't a big deal.
Almost every import process is complicated by import errors, but losing even one value is usually unacceptable.