- In Microsoft Excel, open the workbook or spreadsheet that you want to access from the AutoCAD-based product.
- Select a range of cells to function as a database table.
- Enter a name for the range of cells in the Name Box, then press Enter.
- Repeat steps 2 and 3, if desired, to specify additional database tables.
- 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.