About the Import File Structure for Insert Connector From List

You can select various file types (including XLS, CSV, MDB, and XML) to import into AutoCAD Electrical toolset. For the Insert Connector from List tool to work, the spreadsheet and CSV import file must have the following structure. The spreadsheet for import allows 27 columns per record. The first row in the CSV or XLS file is treated as a header row, and is skipped in the import. All columns must exist and the required fields (bolded) determine the connector to be used in the Connector Selection dialog box.

Note: The structure of this file does not apply to an XML import.

Position	Field	Purpose	Column Type
1	TYPE1	CMP1: C = Connector/ S = Splice	Text
2	INST1	Installation Code of CMP1	Text
3	LOC1	Location Code of CMP1	Text
4	CMP1	Component 1	Text
5	PIN1	Connected pin on CMP1	Text
6	DESC1	Description of CMP1	Text
7	CAT1	Catalog number for CMP1	Text
8	MFG1	Manufacturer of CAT1	Text
9	ASM1	Assembly code for CMP1	Text
10	TYPE2	CMP2: C = Connector/S = Splice	Text
11	INST2	Installation Code of CMP2	Text
12	LOC2	Location Code of CMP2	Text
13	CMP2	Component 2	Text
14	PIN2	Connected pin on CMP2	Text
15	DESC2	Description of CMP2	Text
16	CAT2	Catalog number of CMP2	Text
17	MFG2	Manufacturer of CAT2	Text
18	ASM2	Assembly code for CMP2	Text
19	WIRENO	Wire number (may be blank)	Text
20	WIRELAY	Wire layer name	Text
21	CBLINST	Cable Installation Code	Text
22	CBLLOC	Cable Location Code	Text
23	CBL	Cable tag name	Text
24	CBLWCLR	Cable wire (conductor) color	Text
25	CBLCAT	Cable catalog item	Text
26	CBLMFG	Cable catalog manufacturer	Text
27	CBLASM	Cable assembly code	Text

The MDB file must contain a table with the above mentioned 27 columns. Each column should be defined using the VARCHAR data type of an appropriate size to suit the data. The names of the columns in the table are not important, but the position is.