Change database

if you have a database in access, isn't there some easy way to convert it
into SQL server like an import or similar?You can use the Database Upsizing Wizard. See this article:
http://support.microsoft.com/?kbid=237980
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"John" <Johna@.nospam.nospam> wrote in message
news:eDPEzvSoGHA.4728@.TK2MSFTNGP05.phx.gbl...
> if you have a database in access, isn't there some easy way to convert it
> into SQL server like an import or similar?
>|||Yes, try the Upsizing Wizard. Go to Tools, Database Utilities, Upzising
Wizard. You can move all your objects and data and still have your Access
application pointing to the new SQL Server database.
Ben Nevarez, MCDBA, OCP
Database Administrator
"John" wrote:

> if you have a database in access, isn't there some easy way to convert it
> into SQL server like an import or similar?
>
>|||Try the SSMA for Access tool.
http://www.microsoft.com/sql/soluti...on/default.mspx
joe.
"John" <Johna@.nospam.nospam> wrote in message
news:eDPEzvSoGHA.4728@.TK2MSFTNGP05.phx.gbl...
> if you have a database in access, isn't there some easy way to convert it
> into SQL server like an import or similar?
>