Sunday, February 19, 2012

Importing Access Tables?

Hi,
I have a database in Access 2003. I plan to migrate to SQL Server. Right
now, I have install SQL Server 2005 Express Edition. I have create a new
Database under SQL Server 2005 but stuck in the place because I don't know
how to import existing Access tables to the newly create Database.
Does anyone know how to do this?
SFHello,
You could use SQL Server Integration services (SSIS) to copy the tables from
Access to SQL Server
Thanks
Hari
"SF" <ss@.yahoo.com> wrote in message
news:eFHNntKTHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a database in Access 2003. I plan to migrate to SQL Server. Right
> now, I have install SQL Server 2005 Express Edition. I have create a new
> Database under SQL Server 2005 but stuck in the place because I don't know
> how to import existing Access tables to the newly create Database.
> Does anyone know how to do this?
> SF
>|||Another option is to use the SQL Server Migration Assistant for Access (for
migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/soluti...ss/default.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com

No comments:

Post a Comment