Monday, March 12, 2012

Migrate ACCESS to MSSQL

Hi
I created a table and filled data to it in ACCESS 2002. How can I migrate the ACCESS table data to MSSQL 2000 Server? The table in MSSQL DB has primary key and also has records. I want to append the ACCESS data (2 columns) to the existing table with the same columns names in MSSQL.
How can I do it
ThanksTom,
you can use the upsizing wizard or DTS. Here are some links to help you:
http://builder.com.com/5100-6388-5059624.html
http://support.microsoft.com/default.aspx?kbid=285829
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q237/9/80.ASP&NoWebContent=1
HTH,
Paul Ibison|||Most folks prefer using DTS to the upsizing wizard... However if you do use
the upsizing wizard, go back and ensure that the sql column data types are
appropriate... My experience with the wizard is that it makes the columns
sizes too large.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom" <kerocow@.yahoo.com> wrote in message
news:221ADD36-EA26-45DA-A953-D700866C06F6@.microsoft.com...
> Hi,
> I created a table and filled data to it in ACCESS 2002. How can I migrate
the ACCESS table data to MSSQL 2000 Server? The table in MSSQL DB has
primary key and also has records. I want to append the ACCESS data (2
columns) to the existing table with the same columns names in MSSQL.
> How can I do it?
> Thanks

No comments:

Post a Comment