9. Click on the OK button in the Configure OLE DB Connection Manager
window.
This adds the OLE DB Connection Manager with the same name as that of
the Mdb database file to the OLE DB Destination Editor, TblToAcc, as shown
in the following screenshot.
10. In the third drop-down in this editor, (OLE DB Destination Editor), click on
the drop-down arrow along the label, Name of the Table or View:.
It will try to load but there are no tables or views as the table is empty except
for system tables.
Chapter 6
[ 117 ]
Depending on the version of VS 2005, the OLE DB Destination Editor may
display a New??¦ button alongside Name of the table or the view label.
This will allow you to create a new table instead of creating it manually,
as described.
11. Open the MDB file and keep only four columns (in Table View) and save the
table as TblCH6 after renaming the columns as Product Name, Quantity/
Unit, Price/Unit, and Level.
12. Now click on the drop-down one more time. This time you will see the table
TblCH6, as shown in the following screenshot.
13. Choose this table in the drop-down.
Data Transfer to an MS Access Database
[ 118 ]
14. Next, click on the Mappings list on the left-hand side.
This opens the Mappings window. Either you can associate the input and
output columns by clicking on the input and dragging it to the corresponding
output in the design as indicated, or click on the indicated area in each of
the four rows in the tabulated area below the screen, and associate inputs and
outputs as shown.
Pages:
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