Share this Page URL

Chapter 4. Importing and Linking to Data > Importing Data - Pg. 122

Importing and Linking to Data 5. 6. To select options related to importing a table's definition and data or only the table's definition, click Options. Click OK. 122 Importing Data from Other Data Formats In previous exercises, we concentrated on how to import data from an Excel worksheet and an Access database. As mentioned, you can import data from a number of other formats, including text files, HTML files, and files created in a database program other than Access. The steps you follow to import data in a text file, for example, are similar to those required to import data from Excel. You use the Get External Data, Import command, select the file, and then enter the information the Import Text Wizard requires. In this section, we'll describe some of the details you should know if you are importing data from other formats; however, we won't step through an example using each type. Importing Text Files You might receive data that's been downloaded from a mainframe computer as a text file. A text file you import should be either a delimited text file or a fixed-width text file . A delimited text file uses a comma or another character (a tab, for example) to separate each field in a record. A field in a fixed- width text file is defined by a fixed number of characters. If text in a field has fewer than the prescribed number of characters, spaces fill out the remaining characters. The data in text files, as in spread- sheets, is imported more successfully if you spend time preparing it. You want to be sure that each field is separated by the correct character in a delimited text file. Each field should have the same type of data in it. Any column names you want to use as field names should be the first record in the text file. Text strings in a text file (data you plan to import into fields with the Text data type) should be set off with double quotation marks or another character. If a text value includes the text