Exporting table In application Express

Exporting the Table
Now that you have set up the DSN, the Access Export wizard can use it. If you select a table in
your Access database and choose ODBC Databases from the Export menu, you will see the dialog
box shown in Figure 2-25. This dialog box allows you to name the table that will be created
by the Export wizard. For this example, we selected the Customers table and accepted the
default name.
Next, the wizard will present you with a list of available DSNs. For this example, we
selected the one we created in the previous section, DBTEST, as shown in Figure 2-26. When
you select the DSN, another dialog box appears, where you enter the username, password, and
server. The username field will be filled in with the default value if you supplied one when you
created the DSN. All you need to do here is to enter the password and click OK. The wizard will
migrate the table across to your Oracle database.
If you experience any problems at this stage, the error message that you get from the
Access Export wizard may help you figure out what went wrong. Double-check that you have
entered the correct username and password, and that the Server entry you used matches the
TNSNAME entry you configured.
You can repeat the process to export the data from each table that you want to migrate.
Once you have migrated all the data, you will then be able to create your application using the
Application Builder.