Unanswered: Exporting data from MSSQLServer to MSAccess
I have a MSSQLServer database and I want to transform the database schema in a MSAccess database.
The data into the tables is not important for me.
I desire my MSAccess database has all the tables, primary keys, relationship as like as my MSSQLServer one.
I tryed to export data by DTS wizard of MSSQLServer but it creates all the tables without any primary key and relationship among tables.
How can I export primary keys and relationship too?
Can you help me to solve my problem?