• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Importing and Exporting > Importing Data into Access

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 piece of data from an external source. Indeed, data from outside your computer could be especially likely to break validation rules, exceed field sizes, have the wrong data type, and otherwise breach data integrity.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint