<div>
There is a migration assistant for access tool from Microsoft.You can use that,<br />
<a href="http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en" rel="ugc nofollow">http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en</a><br />
<br />
thanks<br />
Satheesh
</div>


There is a migration assistant for access tool from Microsoft.You can use that,
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en [http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en]

thanks
Satheesh

<div>
Also one more step by step instruction<br />
<a href="http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/" rel="ugc">http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/</a>
</div>


Also one more step by step instruction
http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/ [http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/]

<div>
I am not looking to import access DB just info from the access DB to SQL tables.
</div>


I am not looking to import access DB just info from the access DB to SQL tables.

<div>
<div class="content wysiwyg-content">
I wanted to know how to import data from access into a table in a SQL 2005 database.
</div>
</div>


I wanted to know how to import data from access into a table in a SQL 2005 database.

Importing access data

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.