Also, can somebody please talk me through point 4 of that process (below). I have no idea what it's saying.
4. Use DTS to transfer the data from your Access database to your SQL Server database. You should make sure that for each table the DTS transform column is configured so that any existing table data is deleted and enable identity insert is checked.
You will need to import the data from the Access DB. During the data import process, there will be a step where you will be prompted to choose the tables to import the Data from. You will need to edit the settings for each table, making sure the options to enable identity insert and delete existing records are selected. It's easy to figure out once you see the dialog.
Can i use the SQL Server tool that comes with Microsoft Access 2005 to export the database to the SQL one?
If you are talking about the Upsize Wizard, definitely not!
What is wrong with me! I can't seem to get my numbers right today. Sorry. I meant MS Access 2007. If i open up the database, then go to "database tools" there's a button "sql server", and the roll over says "migrate some or all parts of a database to a new or existing microsoft sql server database".
Topic Locked
Posted - 12 February 2008 : 11:16:59
