Home » Autodesk Manuals » Computer Software » Autodesk 00128-051462-9310 » Manual Viewer

Autodesk 00128-051462-9310 User Guide - Page 1955

Click Select Workbook., Selecting a Database Field

Get Autodesk 00128-051462-9310 - AUTOCAD 2008 COMM UPG FRM 2005 DVD PDF manuals and user guides

UPC - 606121891963

View all Autodesk 00128-051462-9310 manuals

Add to My Manuals
Save this manual to your list of manuals

Page 1955 highlights

14 In the ODBC Microsoft Excel Setup dialog box, select the version of Microsoft Excel that the DSN file should support. 15 Click Select Workbook. 16 Select an XLS file that should be used as your data source, and click OK three times until you are back in the Connection tab of the Data Link Properties dialog box. The Microsoft Excel file you have selected as your data source is displayed under Connection String. 17 To verify that the connection to the data source is working correctly, click Test Connection. 18 Enter a user name and optionally a password for the database connection. 19 Under Enter the initial catalog to use, select the Excel file from the drop-down list. 20 Optionally, you can click the Advanced tab to define network and permission settings. 21 If you have selected a data source on a network server, you can define the network settings. 22 Define the access permissions for the data source. 23 Optionally, you can click the All tab to view and edit the OLE DB initialization properties available for the selected OLE DB provider. 24 Click OK. 25 In the Field dialog box, the selected Excel file is displayed as the data source. You can select data tables and entries as described in "Selecting a Database Field" on page 1911. Creating a Data Link to an ODBC Source | 1915

Section	Page
Contents	5
Workflow and User Interface	41
Introduction	43
New Features	44
A Quick Start for Transitioning from AutoCAD to AutoCAD Architecture	50
Default Content Paths for Microsoft Windows Vista	56
Finding Help	57
Online Help Resources	57
AutoCAD Architecture Design Phases Overview	58
Autodesk Training Programs and Products	59
Autodesk Authorized Training Centers	59
Autodesk Official Training Courseware	59
Autodesk Certification	59
e-Learning	59
Contacting Autodesk	60
Sales Information	60
Technical Support	60
Feedback	60
The Workspace	61
The Workspace Concept	62
Workspace Components	62
The Menu Bar	63
Toolbars	65
Context Menus	66
Tool Palettes	67
Properties Palette	68
AutoCAD Dashboard	68
Drawing Window Status Bar	69
Command Line	70
Application Status Bar	70
Communication Center	71
Project Navigator Palette	71
Changing Workspaces	71
Working with Objects in the Workspace	72
Adding Objects	72
Modifying Objects	73
Selecting Similar Objects	74
Working with Tool Palettes	75
Opening the Tool Palettes Set	76
Controlling the Appearance of the Tool Palettes Set	77
Docking the Tool Palettes Set	77
Hiding the Tool Palettes Set	77
Adjusting the Transparency of the Tool Palettes Set	77
Renaming the Tool Palettes Set	77
Specifying Different Tool Palettes for the Tool Palettes Set	78
Creating a New Tool Palettes Set	78
Creating a New Tool Palettes Group	79
Creating a New Tool Palette	80
Defining the Appearance of Tool Palettes	80
Adding Text and Separator Lines to Tool Palettes	82
Working with Tool Palettes from a Central Location	82
Adding a Tool Palette from a Tool Catalog in the Content Browser	83
Updating a Tool Palette from a Tool Catalog in the Content Browser	84
Tools	84
Creating an Object with a Tool	85
Changing the Tool Properties	86
Changing a Tool Icon	87
Refreshing a Tool Icon	88
Creating a Tool from an Object in the Drawing	89
Copying a Tool from a Tool Palette	89
Creating a Tool from the Style Manager	89
Creating a Tool from AEC Content in DesignCenter	90
Creating a Command Tool	91
Working with Tools from a Central Location	92
Linking a Tool from a Catalog in the Content Browser	92
Updating a Tool in AutoCAD Architecture from the Content Browser	94
Updating a Tool in the Content Browser from a Linked Tool in AutoCAD Architecture	94
Removing the Link of a Tool to a Catalog in the Content Browser	95
Applying the Properties of a Tool to an Existing Object	95
Re-Importing Styles for a Tool	95
Deleting a Tool	96
The Properties Palette	96
Opening the Properties Palette	97
Setting the Appearance of the Properties Palette	97
Docking the Properties Palette	97
Hiding the Properties Palette	97
Adjusting the Transparency of the Properties Palette	97
The Design Tab	98
The Display Tab	98
The Extended Data Tab	99
Worksheets	100
Direct Editing with Grips and Dynamic Dimensions	100
Grip Tips	101
Grip Color	102
Using the CTRL Key with Grips	102
Trigger Grips	103
Dynamic Dimensions	103
Grip Constraints	105
Temporary Grip Coordinate Systems	106
In-Place Editing	106
In-Place Editing of Polyline-Based Components	107
In-Place Editing of Profile-Based Objects and Components	107
In-Place Editing of 3D Body Modifiers	109
In-Place Editing of Material Hatches	110
Aligning the UCS to an Object Face	111
Isolating Objects	112
Isolating Objects to Edit in a Section View	113
Isolating Objects to Edit in an Elevation View	113
Isolating Objects to Edit in a Plan View	114
Isolating Objects to Display	114
Isolating Objects to Hide	115
Ending the Object Isolation in a Drawing	115
Saving Isolated Objects	116
Isolating Objects in External References	116
Styles and Support Files	116
Integration of AutoCAD Architecture and AutoCAD	117
Content Browser	119
Understanding the Content Browser	120
Exploring the Content Browser	121
Viewing a Tool Catalog	121
Specifying the Number of Rows on a Content Browser Page	122
Using the Items in a Tool Catalog	123
Managing Your Catalog Library	123
Creating a New Tool Catalog	123
Creating a Tool Catalog from Content Drawings	124
Adding Tools from Content Drawings to a Tool Catalog	126
Adding an Existing Tool Catalog to Your Catalog Library	127
Creating a Catalog Install File	128
Publishing Tool Catalogs	129
Adding a Website to Your Catalog Library	130
Opening Web Pages in the Content Browser	130
Editing Tool Catalog Properties	130
Creating Catalog Types	131
Sorting Catalogs in the Library View	132
Filtering Catalogs in the Library View	132
Removing a Tool Catalog or Website Link	132
Opening a Different Catalog Library	132
Renaming a Catalog Library	133
Searching for Items in a Tool Catalog	133
Performing a Search	133
Adding Content to a Tool Catalog	134
Defining Categories in a Tool Catalog	136
Adding a Tool Palette to a Tool Catalog	137
Adding a Tool Package to a Tool Catalog	137
Adding Tools to a Tool Catalog	137
Copying and Moving Tool Palettes and Tool Packages	138
Copying and Moving Tools	139
Customizing a Tool	139
Deleting Tool Catalog Items	140
Using Tool Catalog Items in AutoCAD Architecture 2008	140
Linked and Unlinked Tool Catalog Items	140
Using a Tool in the AutoCAD Architecture Workspace	141
Copying a Tool Palette to the AutoCAD Architecture Workspace	141
Copying a Tool Package to the AutoCAD Architecture Workspace	142
Refreshing Linked Tools	143
Refreshing Linked Tool Palettes	143
Specifying Refresh Options for Linked Tool Palettes	143
Working with Multiple Content Browser Windows	144
Opening a Tool Catalog in a New Content Browser Window	144
Opening Catalog Items in a New Content Browser Window	144
Dragging Catalog Items Between Content Browser Windows	144
Starting the Content Browser from a Windows Command Prompt	145
Creating and Saving Drawings	147
About Templates	148
Creating a Drawing from a Template	148
Creating a Drawing Without a Template	149
Opening Legacy Drawings	149
Setting Up a Drawing	149
Specifying the Drawing Units	150
Specifying the Drawing Scale	151
Specifying a Layer Standard and a Layer Key Style	153
Specifying the Default Display Representations	154
Specifying AEC Options	155
Changing the AEC Editor Settings	155
Changing the AEC Content Settings	157
Specifying AEC Object Settings	157
Specifying the Display Resolution of Objects with Facets	158
Changing the AEC Project Defaults	158
Sharing Drawings with AutoCAD Users	159
Comparing Methods of Sharing Drawings	159
Generating Proxy Graphics	160
Exporting a Drawing to AutoCAD	160
Exporting a Drawing to a DXF File	162
Viewport Layer Mapping	162
Interoperability with Other Applications	165
Importing and Exporting IFC Files	166
Architectural Objects and IFC	166
How Drawing Files Are Exported to IFC	167
Drawings with External References	167
Exporting a Drawing with External References	167
Drawings without External References	168
Exporting a Drawing Without External References	169
How IFC Files Are Imported	169
Importing an IFC File	170
Importing LandXML	170
Schema Version	171
Supported Data Types	171
File Validation	173
Importing LandXML Data	174
Selecting Layer Keys for LandXML Data	175
Publishing Drawing Files to Autodesk MapGuide	176
Prerequisites	176
Published Data Types	176
Generating a MWX File	177
An Overview of the Published Data Structure	177
An Overview of the Database Structure	178
Publishing Data to Autodesk MapGuide	179
Exporting Property Set Data to an MDB	180
Publishing Drawings to DWF	180
Publishing Property Data to DWF	181
Process Overview: Publishing a DWG File with Property Set Data to DWF	183
Setting the Publishing Options	183
Creating a New Published Property List (PPL)	184
Publishing a DWF File	185
Drawing Management	189
Concepts of Drawing Management	190
Before You Begin: External References Within a Project	197
Before You Begin: Working in a Network Environment	198
Process Overview: Working in a Project Environment	198
Project Support Files	199
Working with Design Teams Located Remotely	200
Opening a Project From a Mapped Drive	200
Setting the Default Project Options	201
Creating a Sheet Set Template	202
Creating a Template from an Existing Sheet Set	203
Creating a Template from Existing Drawings	207
The Project Browser	210
Using the Project Browser	210
The Project Header	211
The Project Navigation Bar	211
The Project Selector	211
The Embedded Internet Explorer View	213
The Project Structure	213
The Project (APJ) File	213
The Default Category Structure	213
The Project Sheet Set	213
Setting a Project Current	214
Creating a New Project	214
Creating a New Project Based on a Template (Copying a Project)	214
Creating a New Project with the Structure of an Existing Project	216
Creating a New Project Without Using a Template	217
Defining the Project Properties	217
Defining General Properties	218
Adding a Project Library and Tool Palette Group	220
Setting the Detail Component and Keynote Databases for a Project	223
Configuring Project Standards Files	223
Adding Project Details	225
Consolidating Inconsistent Project and Sheet Set Information	225
Moving a Project	226
Renaming a Project	226
Closing a Project	227
Electronically Transmitting a Project	227
Deleting a Project	231
Closing the Project Browser	231
Removing the Project Context	232
Opening a Project from Windows Explorer	232
The Project Navigator	233
Opening the Project Navigator	233
The Tabs of the Project Navigator	233
The Project Tab	233
The Constructs Tab	234
The Views Tab	235
The Sheets Tab	235
Using the Project Navigator	237
The Drawing Explorer	237
The Preview and Detail Panes	238
The Context Menu	238
The Project Navigator Toolbar	240
Drag and Drop in the Project Navigator	241
The Project Status Bar	242
Displaying the Project Tool Palette Group	242
Displaying the Project Library	243
Levels	244
Creating a New Level	245
Copying a Level with Assigned Constructs	246
Changing the Properties of a Level	247
Deleting a Level	247
Changing Levels: Interactions with the Project	248
Divisions	248
Creating a New Division	249
Changing a Division	249
Deleting a Division	250
Changing Divisions: Interactions with the Project	250
Categories	250
Creating a Category in the Project Navigator	252
Creating a Category from Windows Explorer	253
Specifying the Location of Top-Level Categories	254
Redirecting Top-Level Categories	255
Changing the Subcategory of a Project File	255
Creating a File in a Subcategory	255
Changing the Category of an Existing File	256
Deleting a Category	256
Constructs	257
When to Start with Constructs	258
Processing Constructs in the Building Project	258
The Content of Constructs	259
Creating a New Construct	259
Copying Constructs to Levels	261
Converting a Legacy Drawing to a Construct	261
Converting Drawing Files by Opening and Saving	262
Converting Drawing Files from Windows Explorer	262
Opening and Closing a Construct	264
Dragging Objects into a Construct	264
Referencing Elements into Constructs	265
Attaching an Element as an External Reference to a Construct	265
Overlaying an Element as an External Reference to a Construct	266
Inserting an Element as a Block into a Construct	266
Referencing an Element into Multiple Constructs	266
Displaying External References of a Construct	267
Changing the Properties of a Construct	267
Electronically Transmitting a Construct	268
Deleting a Construct	269
Converting a Construct to an Element	270
Changing Constructs: Interactions with the Project	270
Elements	271
When to Start with Elements	272
Processing Elements in the Building Project	273
Creating a New Element	273
Converting a Legacy Drawing to an Element	274
Converting Drawing Files by Opening and Saving	275
Converting Drawing Files from Windows Explorer	275
Opening and Closing an Element	277
Dragging Objects into an Element	277
Changing the Properties of an Element	278
Electronically Transmitting an Element	278
Deleting an Element	279
Referencing an Element into Another Element	279
Displaying External References of an Element	280
Converting an Element to a Construct	281
Changing Elements: Interactions with the Project	281
Views	282
When to Start with Views	285
Process Overview: Creating a General View Drawing	286
Creating a New General View Drawing	286
Creating a View Drawing: Defining General Properties	286
Creating a View Drawing: Assigning Levels and Divisions	288
Creating a View Drawing: Selecting the Constructs	288
Displaying External References of a View Drawing	289
Opening and Closing a View Drawing	290
Creating a Specialized View Drawing	291
Changing the Properties of a View Drawing	292
Regenerating a View Drawing	293
Placing a View Drawing onto a Sheet	293
Electronically Transmitting a View Drawing	294
Deleting a View Drawing	295
Creating a Model Space View	295
Placing a Model Space View onto a Sheet	297
Changing the Properties of a Model Space View	298
Deleting Model Space Views	298
Synchronizing View Drawing Layers with Sheet View Layers	299
Process Overview: Synchronizing View Drawing Layers with Sheet View Layers	300
Postlinking a Legacy View Drawing to a Sheet View	301
Configuring an Existing Project to Synchronize View Drawing Layers with Sheet View Layers	301
Changing Views: Interactions with the Project	302
Plotting Sheets	302
When to Start with Plotting Sheets	305
Setting the Properties of the Project Sheet Set	305
Setting the Properties of a Sheet Subset	307
Creating a Sheet Subset	308
Removing a Sheet Subset	308
Creating a New Sheet	309
Importing Sheets into the Sheet Set	310
Registering the Current Sheet in the Sheet Set	311
Opening and Closing a Sheet	311
Changing the Properties of a Sheet	312
Removing a Sheet from the Sheet Set	312
Deleting a Sheet from the Project	313
Deleting a Sheet	313
Deleting a Sheet Drawing	313
Creating a New Sheet View	313
Opening a Sheet View	314
Numbering Sheet Views	314
Deleting a Sheet View	314
Displaying External References of a Sheet Drawing	315
Inserting a Sheet List	315
Changing a Sheet List	317
Updating the Sheet List	317
Refreshing the Sheet Set	317
Creating a Sheet Selection	318
Activating a Sheet Selection	318
Deleting a Sheet Selection	318
Electronically Transmitting Sheets and Sheet Sets	319
Archiving a Sheet Set	322
Publishing Sheet Sets	326
Defining the Plot Stamp Settings	326
Assigning a Plot Stamp to a Publication Set	328
Managing Page Setups	328
Publishing Sheets and Sheet Sets	329
Publishing Sheet Sets Using a Page Setup Override	331
Publishing a Sheet Set in Reverse Order	332
Changing Plotting Sheets: Interactions with the Project	332
Updating (Re-path) the Project	332
Refreshing the Project View	334
Object Display in External References	334
Using the External Display Configuration	335
Using the External Display Configuration with the Object Enabler	335
Example: Displaying Part of the Model as Background	336
Annotating a Building Project	337
Generating Spaces and Space Schedules	337
Tagging a Project	337
Property Set Data and Schedule Tables in Projects	338
Process Overview: Creating Property Sets and Schedule Tables in a Project	338
Project Schedule Properties	339
Creating a Property Set Definition with Project Property Definitions	340
Attaching Property Sets to Objects from External References	341
Creating a Schedule Table for a Project	342
Example: Numbering a Door in a Project	343
Creating a Title Block for a Project	345
Process Overview: Creating a Title Block for a Project	345
Adding Project Attributes	345
Creating a Project Block	346
Creating a Multi-View Block	346
Creating a Tool for the Title Block	347
Inserting the Title Block into a Drawing	347
Dimensioning a Project	347
Working with Cut Planes in a Project	348
Global Cut Planes	350
Global Cut Plane Display Range	350
Display Properties for the Cut Plane Display Range	351
Setting the Global Cut Plane and the Display Range	351
Using the Global Cut Plane: Displaying the Cut Plane of a Different Level	352
Using the Global Cut Plane: Creating a Clipped Model View	353
Object-Specific Cut Planes	355
Object-Specific Cut Plane Overrides	355
Example: Overriding the Cut Plane for a Wall	355
Cut Planes from the Anchoring Object	356
Example: Using the Cut Plane of the Anchoring Object	356
Manual Cut Planes	356
Running Drawing Management from the Command Line	357
Command Line: Opening the Project Browser	357
Command Line: Opening the Project Navigator	357
Command Line: Refreshing the Project	357
Command Line: Regenerating Views	358
Command Line: Selecting a New Project Environment	358
Command Line: Closing the Project Navigator	358
Frequently Asked Questions about Drawing Management	358
Appendix 1: Template Projects	360
Understanding Project Navigator	361
Levels and Divisions	362
Adding a Level to a Project Created from the Commercial Template Project	362
Deleting a Level from a Project Created from the Commercial Template Project	363
Project File Naming	363
Understanding Constructs Included in the Commercial Template Project	365
General Considerations for all Constructs	365
Terrain Construct	365
Shell Construct	365
Core Construct	366
Slab Construct	366
Interior Construct	366
Stairs Construct	366
Roof Construct	366
Column Grid Construct	366
Understanding the Element File Included in the Commercial Template Project	367
Typical Toilet Room Element	367
Understanding Views Included in the Template Project	367
Consultant Backgrounds	367
Detail Views	367
Enlarged Views	367
Floor Plan Views	368
3D Model Views	368
Reflected Ceiling Plan Views	368
Schedule Views	368
Elevation and Section Views	368
Understanding Sheets Included in the Template Project	368
Project Standards	368
Project Standards	371
Project Standards Terminology	372
Project Standards Overview	373
AEC Standards	373
AutoCAD Standards	374
Standard Tools	374
Synchronizing the Project	375
Process Overview: Using Standards in a Project	375
Using Project Standards	375
Prerequisites for Working with Project Standards	376
Setting up Standards in a Project	376
Creating a New Project with Predefined Standards	376
Configuring Project Standards	377
Setting up Standard Styles and Display Settings	377
Synchronization Options	380
Setting up Synchronization of AEC Standards	381
Setting up AutoCAD Standards	382
Copying Project Standards from Another Project	383
Enabling Project Standards for a Project	384
Generating a Project Standards Setup Report	385
Setting up Standard Tools in a Project	385
Creating a Tool Catalog for a Project	387
Creating a Project Standards Tool Catalog	387
Adding Standard Tools to a Tool Catalog	388
Adding a Project Catalog to a Content Browser Library	390
Adding a Project Library and Tool Palette Group	391
Displaying the Project Tool Palette Group	393
Building the Tool Palette Group	394
Copying the Project Tool Palettes to the Tool Palette File Location	395
Adding the Project Profile to the Tool Palette File Location	395
Adding Standards to a Project Drawing	395
Project Tool Palette Group	396
Adding Standard Styles from the Project Tool Palettes	396
Adding Standard Styles from Content Browser	396
Adding Standard Styles from Style Manager	397
Adding Standard Display Settings from Display Manager	398
Synchronizing a Project with the Standards	398
Synchronization Status	400
Synchronizing a Project with AEC Standards	401
Synchronization Exceptions	403
Synchronizing a Project Drawing with AEC Standards	403
Synchronizing Selected Styles and Display Settings with AEC Standards	404
Synchronizing Individual Styles with AEC Standards	407
Synchronizing Individual Display Settings with AEC Standards	407
Excluding Styles and Display Settings from Synchronization	408

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1,000
1,001
1,002
1,003
1,004
1,005
1,006
1,007
1,008
1,009
1,010
1,011
1,012
1,013
1,014
1,015
1,016
1,017
1,018
1,019
1,020
1,021
1,022
1,023
1,024
1,025
1,026
1,027
1,028
1,029
1,030
1,031
1,032
1,033
1,034
1,035
1,036
1,037
1,038
1,039
1,040
1,041
1,042
1,043
1,044
1,045
1,046
1,047
1,048
1,049
1,050
1,051
1,052
1,053
1,054
1,055
1,056
1,057
1,058
1,059
1,060
1,061
1,062
1,063
1,064
1,065
1,066
1,067
1,068
1,069
1,070
1,071
1,072
1,073
1,074
1,075
1,076
1,077
1,078
1,079
1,080
1,081
1,082
1,083
1,084
1,085
1,086
1,087
1,088
1,089
1,090
1,091
1,092
1,093
1,094
1,095
1,096
1,097
1,098
1,099
1,100
1,101
1,102
1,103
1,104
1,105
1,106
1,107
1,108
1,109
1,110
1,111
1,112
1,113
1,114
1,115
1,116
1,117
1,118
1,119
1,120
1,121
1,122
1,123
1,124
1,125
1,126
1,127
1,128
1,129
1,130
1,131
1,132
1,133
1,134
1,135
1,136
1,137
1,138
1,139
1,140
1,141
1,142
1,143
1,144
1,145
1,146
1,147
1,148
1,149
1,150
1,151
1,152
1,153
1,154
1,155
1,156
1,157
1,158
1,159
1,160
1,161
1,162
1,163
1,164
1,165
1,166
1,167
1,168
1,169
1,170
1,171
1,172
1,173
1,174
1,175
1,176
1,177
1,178
1,179
1,180
1,181
1,182
1,183
1,184
1,185
1,186
1,187
1,188
1,189
1,190
1,191
1,192
1,193
1,194
1,195
1,196
1,197
1,198
1,199
1,200
1,201
1,202
1,203
1,204
1,205
1,206
1,207
1,208
1,209
1,210
1,211
1,212
1,213
1,214
1,215
1,216
1,217
1,218
1,219
1,220
1,221
1,222
1,223
1,224
1,225
1,226
1,227
1,228
1,229
1,230
1,231
1,232
1,233
1,234
1,235
1,236
1,237
1,238
1,239
1,240
1,241
1,242
1,243
1,244
1,245
1,246
1,247
1,248
1,249
1,250
1,251
1,252
1,253
1,254
1,255
1,256
1,257
1,258
1,259
1,260
1,261
1,262
1,263
1,264
1,265
1,266
1,267
1,268
1,269
1,270
1,271
1,272
1,273
1,274
1,275
1,276
1,277
1,278
1,279
1,280
1,281
1,282
1,283
1,284
1,285
1,286
1,287
1,288
1,289
1,290
1,291
1,292
1,293
1,294
1,295
1,296
1,297
1,298
1,299
1,300
1,301
1,302
1,303
1,304
1,305
1,306
1,307
1,308
1,309
1,310
1,311
1,312
1,313
1,314
1,315
1,316
1,317
1,318
1,319
1,320
1,321
1,322
1,323
1,324
1,325
1,326
1,327
1,328
1,329
1,330
1,331
1,332
1,333
1,334
1,335
1,336
1,337
1,338
1,339
1,340
1,341
1,342
1,343
1,344
1,345
1,346
1,347
1,348
1,349
1,350
1,351
1,352
1,353
1,354
1,355
1,356
1,357
1,358
1,359
1,360
1,361
1,362
1,363
1,364
1,365
1,366
1,367
1,368
1,369
1,370
1,371
1,372
1,373
1,374
1,375
1,376
1,377
1,378
1,379
1,380
1,381
1,382
1,383
1,384
1,385
1,386
1,387
1,388
1,389
1,390
1,391
1,392
1,393
1,394
1,395
1,396
1,397
1,398
1,399
1,400
1,401
1,402
1,403
1,404
1,405
1,406
1,407
1,408
1,409
1,410
1,411
1,412
1,413
1,414
1,415
1,416
1,417
1,418
1,419
1,420
1,421
1,422
1,423
1,424
1,425
1,426
1,427
1,428
1,429
1,430
1,431
1,432
1,433
1,434
1,435
1,436
1,437
1,438
1,439
1,440
1,441
1,442
1,443
1,444
1,445
1,446
1,447
1,448
1,449
1,450
1,451
1,452
1,453
1,454
1,455
1,456
1,457
1,458
1,459
1,460
1,461
1,462
1,463
1,464
1,465
1,466
1,467
1,468
1,469
1,470
1,471
1,472
1,473
1,474
1,475
1,476
1,477
1,478
1,479
1,480
1,481
1,482
1,483
1,484
1,485
1,486
1,487
1,488
1,489
1,490
1,491
1,492
1,493
1,494
1,495
1,496
1,497
1,498
1,499
1,500
1,501
1,502
1,503
1,504
1,505
1,506
1,507
1,508
1,509
1,510
1,511
1,512
1,513
1,514
1,515
1,516
1,517
1,518
1,519
1,520
1,521
1,522
1,523
1,524
1,525
1,526
1,527
1,528
1,529
1,530
1,531
1,532
1,533
1,534
1,535
1,536
1,537
1,538
1,539
1,540
1,541
1,542
1,543
1,544
1,545
1,546
1,547
1,548
1,549
1,550
1,551
1,552
1,553
1,554
1,555
1,556
1,557
1,558
1,559
1,560
1,561
1,562
1,563
1,564
1,565
1,566
1,567
1,568
1,569
1,570
1,571
1,572
1,573
1,574
1,575
1,576
1,577
1,578
1,579
1,580
1,581
1,582
1,583
1,584
1,585
1,586
1,587
1,588
1,589
1,590
1,591
1,592
1,593
1,594
1,595
1,596
1,597
1,598
1,599
1,600
1,601
1,602
1,603
1,604
1,605
1,606
1,607
1,608
1,609
1,610
1,611
1,612
1,613
1,614
1,615
1,616
1,617
1,618
1,619
1,620
1,621
1,622
1,623
1,624
1,625
1,626
1,627
1,628
1,629
1,630
1,631
1,632
1,633
1,634
1,635
1,636
1,637
1,638
1,639
1,640
1,641
1,642
1,643
1,644
1,645
1,646
1,647
1,648
1,649
1,650
1,651
1,652
1,653
1,654
1,655
1,656
1,657
1,658
1,659
1,660
1,661
1,662
1,663
1,664
1,665
1,666
1,667
1,668
1,669
1,670
1,671
1,672
1,673
1,674
1,675
1,676
1,677
1,678
1,679
1,680
1,681
1,682
1,683
1,684
1,685
1,686
1,687
1,688
1,689
1,690
1,691
1,692
1,693
1,694
1,695
1,696
1,697
1,698
1,699
1,700
1,701
1,702
1,703
1,704
1,705
1,706
1,707
1,708
1,709
1,710
1,711
1,712
1,713
1,714
1,715
1,716
1,717
1,718
1,719
1,720
1,721
1,722
1,723
1,724
1,725
1,726
1,727
1,728
1,729
1,730
1,731
1,732
1,733
1,734
1,735
1,736
1,737
1,738
1,739
1,740
1,741
1,742
1,743
1,744
1,745
1,746
1,747
1,748
1,749
1,750
1,751
1,752
1,753
1,754
1,755
1,756
1,757
1,758
1,759
1,760
1,761
1,762
1,763
1,764
1,765
1,766
1,767
1,768
1,769
1,770
1,771
1,772
1,773
1,774
1,775
1,776
1,777
1,778
1,779
1,780
1,781
1,782
1,783
1,784
1,785
1,786
1,787
1,788
1,789
1,790
1,791
1,792
1,793
1,794
1,795
1,796
1,797
1,798
1,799
1,800
1,801
1,802
1,803
1,804
1,805
1,806
1,807
1,808
1,809
1,810
1,811
1,812
1,813
1,814
1,815
1,816
1,817
1,818
1,819
1,820
1,821
1,822
1,823
1,824
1,825
1,826
1,827
1,828
1,829
1,830
1,831
1,832
1,833
1,834
1,835
1,836
1,837
1,838
1,839
1,840
1,841
1,842
1,843
1,844
1,845
1,846
1,847
1,848
1,849
1,850
1,851
1,852
1,853
1,854
1,855
1,856
1,857
1,858
1,859
1,860
1,861
1,862
1,863
1,864
1,865
1,866
1,867
1,868
1,869
1,870
1,871
1,872
1,873
1,874
1,875
1,876
1,877
1,878
1,879
1,880
1,881
1,882
1,883
1,884
1,885
1,886
1,887
1,888
1,889
1,890
1,891
1,892
1,893
1,894
1,895
1,896
1,897
1,898
1,899
1,900
1,901
1,902
1,903
1,904
1,905
1,906
1,907
1,908
1,909
1,910
1,911
1,912
1,913
1,914
1,915
1,916
1,917
1,918
1,919
1,920
1,921
1,922
1,923
1,924
1,925
1,926
1,927
1,928
1,929
1,930
1,931
1,932
1,933
1,934
1,935
1,936
1,937
1,938
1,939
1,940
1,941
1,942
1,943
1,944
1,945
1,946
1,947
1,948
1,949
1,950
1,951
1,952
1,953
1,954
1,955
1,956
1,957
1,958
1,959
1,960
1,961
1,962
1,963
1,964
1,965
1,966
1,967
1,968
1,969
1,970
1,971
1,972
1,973
1,974
1,975
1,976
1,977
1,978
1,979
1,980
1,981
1,982
1,983
1,984
1,985
1,986
1,987
1,988
1,989
1,990
1,991
1,992
1,993
1,994
1,995
1,996
1,997
1,998
1,999
2,000
2,001
2,002
2,003
2,004
2,005
2,006
2,007
2,008
2,009
2,010
2,011
2,012
2,013
2,014
2,015
2,016
2,017
2,018
2,019
2,020
2,021
2,022
2,023
2,024
2,025
2,026
2,027
2,028
2,029
2,030
2,031
2,032
2,033
2,034
2,035
2,036
2,037
2,038
2,039
2,040
2,041
2,042
2,043
2,044
2,045
2,046
2,047
2,048
2,049
2,050
2,051
2,052
2,053
2,054
2,055
2,056
2,057
2,058
2,059
2,060
2,061
2,062
2,063
2,064
2,065
2,066
2,067
2,068
2,069
2,070
2,071
2,072
2,073
2,074
2,075
2,076
2,077
2,078
2,079
2,080
2,081
2,082
2,083
2,084
2,085
2,086
2,087
2,088
2,089
2,090
2,091
2,092
2,093
2,094
2,095
2,096
2,097
2,098
2,099
2,100
2,101
2,102
2,103
2,104
2,105
2,106
2,107
2,108
2,109
2,110
2,111
2,112
2,113
2,114
2,115
2,116
2,117
2,118
2,119
2,120
2,121
2,122
2,123
2,124
2,125
2,126
2,127
2,128
2,129
2,130
2,131
2,132
2,133
2,134
2,135
2,136
2,137
2,138
2,139
2,140
2,141
2,142
2,143
2,144
2,145
2,146
2,147
2,148
2,149
2,150
2,151
2,152
2,153
2,154
2,155
2,156
2,157
2,158
2,159
2,160
2,161
2,162
2,163
2,164
2,165
2,166
2,167
2,168
2,169
2,170
2,171
2,172
2,173
2,174
2,175
2,176
2,177
2,178
2,179
2,180
2,181
2,182
2,183
2,184
2,185
2,186
2,187
2,188
2,189
2,190
2,191
2,192
2,193
2,194
2,195
2,196
2,197
2,198
2,199
2,200
2,201
2,202
2,203
2,204
2,205
2,206
2,207
2,208
2,209
2,210
2,211
2,212
2,213
2,214
2,215
2,216
2,217
2,218
2,219
2,220
2,221
2,222
2,223
2,224
2,225
2,226
2,227
2,228
2,229
2,230
2,231
2,232
2,233
2,234
2,235
2,236
2,237
2,238
2,239
2,240
2,241
2,242
2,243
2,244
2,245
2,246
2,247
2,248
2,249
2,250
2,251
2,252
2,253
2,254
2,255
2,256
2,257
2,258
2,259
2,260
2,261
2,262
2,263
2,264
2,265
2,266
2,267
2,268

Match case Limit results 1 per page

In the ODBC Microsoft Excel Setup dialog box, select the version of Microsoft Excel that the DSN file should

support.

Click Select Workbook.

Select an XLS file that should be used as your data source, and click OK three times until you are back in

the Connection tab of the Data Link Properties dialog box.

The Microsoft Excel file you have selected as your data source is displayed under Connection String.

To verify that the connection to the data source is working correctly, click Test Connection.

Enter a user name and optionally a password for the database connection.

Under Enter the initial catalog to use, select the Excel file from the drop-down list.

Optionally, you can click the Advanced tab to define network and permission settings.

If you have selected a data source on a network server, you can define the network settings.

Define the access permissions for the data source.

Optionally, you can click the All tab to view and edit the OLE DB initialization properties available for the

selected OLE DB provider.

Click OK.

In the Field dialog box, the selected Excel file is displayed as the data source.

You can select data tables and entries as described in

“

Selecting a Database Field

”

on page 1911.

Creating a Data Link to an ODBC Source |

1915