Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Importing Data into Access

Importing data into Access can be like trying to re-enter the United States after traveling overseas. Sometimes the process goes so smoothly you wonder what you were worried about. Other times, there seems to be an officious agent standing at the gateway of your Access table, making it as difficult as possible to let any data in.

But there's good reason for the intrusive inspection. When it comes to the domestic security of any nation, it doesn't make sense to worry exclusively about internal threats and be indifferent about who is entering your country. Similarly, it makes little sense to put tremendous effort into maintaining data integrity for values you enter directly into Access yourself while waving through any ...