Import Access tables into SQL

Still really new at all this, but learning lots thanks to this forum.

I was wondering - is there a way to import Access tables into my SQL Server 2005 ?

(The Data and the Table Design?)

Go to Microsoft SQL Server Management studio. select your database or create a new database. in database explorer right click on database , select all tasks , and there select import data there you will be asked source database select access file. and get import it

krishna

|||

Thanks for your reply.

I right click, but I don't get an import option.

What am I doing wrong ?

I've got Shrink, Detach, Backup, Restore, and Generate scripts.

|||

Please don't tell me this is yet another "should be super simple - but the Microsoft tools can't do it" type functions.

I kick myself everyday for not starting these projects in PHP / MySQL.

As someone in this forum has said on a few occasions..... 'ASP.NET......... it makes the Hard stuff easy, but makes the easy stuff hard'.