sql server new users: Getting Access Data into SQL Server 2005 -- sql server new users

You're in the

sql server new users

group:

Getting Access Data into SQL Server 2005

ibeetb
4/23/2006 8:53:50 PM

sql server new users:

We have tables of data with about 10000 rows. What is the best way to get
this data into Sql Server 2005. We want toi transfer from Access 2003 to Sql
Server 2005 and want our access data in a sql server table

Re: Getting Access Data into SQL Server 2005

Andrew Watt [MVP]
4/24/2006 12:00:00 AM

[quoted text, click to view]

Hi,

You can use the Import and Export Wizard to import data from Access
2003 to SQL Server 2005.

Re: Getting Access Data into SQL Server 2005

lara169
4/24/2006 12:00:00 AM

Also you can use OPENROWSET

[quoted text, click to view]

Re: Getting Access Data into SQL Server 2005

Roger Wolter[MSFT]
4/24/2006 10:05:15 AM

Or the Access upsizing Wizard in the Access tools menu.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: Getting Access Data into SQL Server 2005

Chuck Heinzelman
4/24/2006 11:40:56 PM

Or, if you already have a database in SQL Server 2005 that you would like to
put the data into, you could use SSIS to move the data.

Chuck Heinzelman
MCSD, MCDBA

I support the Professional Association for SQL Server (www.sqlpass.org)

This posting is not an endoresment of any product. Information is provided
as-is, and carries no warranties - either express or implied.

Please respond in newsgroups only.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn