O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exporting Access Tables to a Client/Server Database

Creating the definition of tables in a client/server database can be a very lengthy process, especially if you need to write SQL DDL statements in ISQL/w to create the tables. SQL Server's SQL Enterprise Manager simplifies the process of creating new client/server tables. It's even easier, however, to export your existing Access tables to a database in SQL Server. When you export Access tables to SQL Server, you ensure that the SQL Server table's field data types correspond to the data types of your Access table.

Using Access's Built-In Export Feature

To export a table from Northwind.mdb to the pubs database, follow these steps:

1.
Open Northwind.mdb. In the Tables page of the Database window, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required