Has anyone succesfully copy table accross from ACCESS to SQL*Server along with its Primary Key and indexes information?

I managed to copy the table over but it removes all the primary key setting.

Any feedback is appreciated.

Thanks in advance,
Asfen