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

Chapter 3. Getting Information Into and ... > Importing Information from a Delimit...

Importing Information from a Delimited Text File

Text files are the common denominator of documents. Almost every program that works with words and numbers can generate some kind of a text file, in addition to files in its native format. Access can import tabular data (tables and lists) from text files if the data has been stored in a recognizable format. The most common formats are called delimited and fixed width (which will be discussed later in this chapter).


In a delimited text file, each record ends in a carriage return, and each field is separated from the next by a comma or some other special character, called a delimiter. If a field contains one of these special characters, you must enclose the entire field in quotation marks. (Some people enclose all fields in quotation marks to avoid having to locate and enclose the special cases.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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