Importing tabular data documents

You can import tabular data into your document by first saving the files (such as Microsoft Excel files or database files) as delimited text files.

For information on importing and formatting table data, see Importing and exporting tabular data. For information about importing text from Microsoft Word HTML documents, see Opening existing documents.

You can also add text from Microsoft Excel documents to a Dreamweaver document by importing the contents of the Excel file into a web page (see Importing Microsoft Office documents (Windows only)).

To import tabular data:

  1. Select File > Import > Import Tabular Data, or Insert > Table Objects > Import Tabular Data.

    The Import Table dialog box appears.

  2. Browse for the file you want or enter its name in the text box.
  3. Select the delimiter used when the file was saved as delimited text. Your options are Tab, Comma, Semicolon, Colon, and Other.

    If you select Other, a blank field appears next to the option. Enter the character that was used as a delimiter.

  4. Use the remaining options to format or define the table into which the data will be imported.
  5. Click OK.