MS SQL Server - converting Access 2003 to SQL Server 2005 Express

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

converting Access 2003 to SQL Server 2005 Express

chris123

2006-02-13, 7:23 am

Hi,

I want to convert/upsize an Acces 2003 to SQL server 2005 express.
Can anyone tell me if this will work?
(I'm a bit nervous about trying it as I'm new to SQL Server!)

1. Convert Access database to SQL server 2000 database using 'Upsizing
Wizard' in Access 2003.

2. Use SQL Server Express Utility:
(It says on the link below that you can 'Upgrade database files to match the
version of the server'). see below:

http://www.microsoft.com/downloads/...&displaylang=en

Would this work?
Try not to use too much techie language please, I'm a relative beginner!

Thanks

Sponsored Links