Hi y`all,

Has anyone tried this before?

Exporting table from Access97 to SQL*Server 6.5 is not a problem, however...
this process does not export the `Primary Key` and `Index` informations. It actually convert all the fieds in the table to NULL allowed, thus preventing even a dba to add a Primary Key.

Is there an easy way to perform this task? Your feedback is mostly appreciated.

Cheers,
Asfen