<div>
Please check the following blog for same:<br />
<a href="http://quest4gen.blogspot.com/2009/12/load-ms-access-data-to-sql-server.html" rel="ugc">http://quest4gen.blogspot.com/2009/12/load-ms-access-data-to-sql-server.html</a>
</div>


Please check the following blog for same:
http://quest4gen.blogspot.com/2009/12/load-ms-access-data-to-sql-server.html [http://quest4gen.blogspot.com/2009/12/load-ms-access-data-to-sql-server.html]

<div>
Thank you...<br />
That speaks to moving tables. &nbsp;What about views and stored procedures? &nbsp;Will that work too?
</div>


Thank you...
That speaks to moving tables.  What about views and stored procedures?  Will that work too?

<div>
Are you trying to tell me the is NO WAY to accomplish this except cut and paste? &nbsp;
</div>


Are you trying to tell me the is NO WAY to accomplish this except cut and paste?  

<div>
<div class="content wysiwyg-content">
I need to move the tables and queries in an Access 2003 mdb file into a sql 2005 database. &nbsp;Will SSIS do this? &nbsp;If so, how?<br />
Thanks.
</div>
</div>


I need to move the tables and queries in an Access 2003 mdb file into a sql 2005 database.  Will SSIS do this?  If so, how?
Thanks.

Access 2003 MDB to SQL 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.