Hey guys,
I had a look around but couldn't find anything pertaining to my issue but if there is and I missed it then I apologise in advance.
I have an older database in Access 2000 that has information in it that needs to be brought over to a new database in SQL Server 2005 (I'm extremely new to SQL Server so forgive any idiotic things I might say). I was thinking that I would just convert the Access Db to SQL Server format by using the Upsizing Wizard however since the Access Db uses data taken from another Access Db will they still be linked if I upsize them both? Or will that cause errors and such.
I would love to import the data directly but the new Db, although used for the same thing is structured very differently and has different table names etc.
Any help would be much appreciated.
Thanks,
Chaz