Chapter 6
[ 115 ]
3. Click on the New... button right next to the first drop-down.
This will look for a New OLE DB connection manager by opening the
Configure OLE DB Connection Manager window. This window may
display existing OLE DB connections in the left-hand side under the label
"Data Connections:".
4. Click on the New... button.
This opens the Connection Manager window shown in the
following screenshot.
Microsoft Access Databases are accessed by Microsoft Jet 4.0 OLE DB providers.
5. Click on the first drop-down along the label, "Providers:".
This will display a list of providers.
Data Transfer to an MS Access Database
[ 116 ]
6. In this list, click on the Microsoft Jet 4.0 OLE DB Provider.
Now you need to provide a database file name. You may browse and choose
an existing MS Access database file, or create one inside the window of the
Open dialogue and choose that file.
7. For this exercise, create a file TblToAcc.mdb and choose this file while
browsing.
This action will get the path to this file into the Connection Manager
window.
Admin is the default username and it does not need a password as the
administrator is also the present user. You may also test the connection with
the Test Connection button. You should get a connection succeeded message
from the connection manager.
8. Click on the OK button in the Connection Manager window. This adds the
Data Connection to the Configure OLE DB Connection Manager window,
as shown in the following screenshot.
Pages:
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