Import data from Access to SqlServer 2000

Currently I'm trying to convert an Access database
to a SqlServer 2000 database. For this purpose
I use the import and export data to forfill this task.
But the problem is :

Primary keys and Foreign keys are not converted
from the Access database to the SqlServer database.

I presume this is a standard newby error, but how can I solve it?

many thanx in advance,
Arnold

Not converted? I'm not sure what you mean by this.

Use the DTS tool, and choose the "import objects" option. Once the data is moved across, check your tables have their fields setup corectly... e.g. your PK's etc.

I can't define conversion very accurate for you.
But I will give it a try :
One RDBMS is Access ( the source RDBMS ), the other is SqlServer ( the target RDBMS )
All tables, constraints, keys are in the source RDBMS and they should be copied
to the target RDBMS.

The DTS Import/export wizard doesn't convert the foreign and primary keys fine.
Therefore I'm currently using the upsizing wizard of Access. Still some errors are made during this conversion.
Some foreign keys are removed in the target database, without a real reason. And some columns are added without a question
or a real reason.

And sorry, but the total amount of tables is far too much to check them manually.

If someone has got a real answer, and a real solution.
I would appreciate it.

Simply go into your access database, go to the tools menu, database utilities, upsizing wizard.
This will automatically import the mdb file into sql2000.
any probs or questions, post back