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

Importing Text Files

If the data you want to import into a Jet table was developed in a database management system, word processor, 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. Most DOS- and Windows-compatible data files created from data stored by mainframes and mini-computers, and files generated from nine-track magnetic tapes are text files.

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; 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