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

Importing Text Files

If the data you want to import into an Access table was developed in a word processor, database, or other application that can't export the data as a .dbf, .wk?, or .xls file, you need to create a text file in one of the text formats supported by Access. (A text file is a file with data consisting of characters that you can read with a text editor, such as Windows Notepad or the DOS EDIT.COM text editor.) Most DOS- and Windows-compatible data files created from data in mainframe computers and files converted from nine-track magnetic tapes are text files, and Access imports these files in various formats.

Access refers to the characters that separate fields as delimiters or separators. In this book, the term delimiter refers to characters that identify the end of a field; the term text identifiers refers to the single and double quotation marks that you can use to distinguish text from numeric data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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