To set up a Microsoft Excel spreadsheet to use with AutoCAD
- In Microsoft Excel, open the workbook or spreadsheet that you want to access from AutoCAD.
- 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 menu
Save
.
At the command prompt,
enter SAVE.
NoteMicrosoft Excel is not
a true database management system. In order to access Excel data
from within AutoCAD, 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 by AutoCAD.