Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-04 : 08:44:03
|
| radmil writes "Is there any way to export SQL server database to Access database with keeping Primary key as AutoNumber. (I have exported all data from SQL server to Access database but all Primary keys in new Access database er defined as Number-Long Integer, not as Auto Number)" |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-04 : 21:42:41
|
quote:
Originally posted by AskSQLTeam
radmil writes "Is there any way to export SQL server database to Access database with keeping Primary key as AutoNumber. (I have exported all data from SQL server to Access database but all Primary keys in new Access database er defined as Number-Long Integer, not as Auto Number)"
Types dont always match, why cant you modify the access db? ??Simply highlight that row and select the key icon, then select autonumber in the type, save the db and voila ? A new beat on the web -- http://www.web-impulse.com |
 |
|
|
|
|
|
export SQL database to access