Microsoft® Office Access™ 2007 Plain & Simple

Importing Data from a Text File

In the early days of personal computing, it was very hard to transfer data between programs and, in some cases, between computers. Different computers used different types of disks, programs created files that no other programs could read, and organizations developed solutions that didn’t enable information workers to collaborate effectively. However, most programs knew how to deal with data stored as a text file. That’s still the case today. If you absolutely must work with data from a program that can’t create another data format Access understands, you can always have your colleagues export their data as a text file. Access knows how to convert text files to database tables, which then enables you to integrate ...