To Set Up a Microsoft Excel Spreadsheet

  1. In Microsoft Excel, open the workbook or spreadsheet that you want to access from the AutoCAD-based product.
  2. Select a range of cells to function as a database table.
  3. Enter a name for the range of cells in the Name Box, then press Enter.
  4. Repeat steps 2 and 3, if desired, to specify additional database tables.
  5. Click File Save.
Note: Microsoft Excel is not a true database management system. In order to access Excel data from within the program, you must first specify at least one named range of Excel cells to function as a database table. Each named range of cells that you specify within a spreadsheet is treated as an individual table.