Access -export-> MS SQL 2005

how can i export all the content of an access database into a MS SQL 2005 database, with of course similar tables ?
thank youI don't know about SQL 2005 since I've never used it, but in SQL 2000 you can simply import an Access database in its entirety using a single DTS package. Does that help?|||ok i try !

thank you|||Another way would be to use the Upsizing Wizard within Access. You can find it in the 'Tools>Database Utilities' menu within Access.|||ok thank's a lot|||Hi Quentin

The upsizing wizard is a nice utility (and I would use it too) but remember to go through the migrated tables and check that the wizard has chosen the most appropriate (read correct) data types as there is not a simple 1 to 1 mapping from JET to SQL Server.

HTH|||i have to migrate t SQL in the next 2 weeks a big and full access database :-)

thanks to everyboy