<div>
yes, using LinkedServer.<br />
<br />
<a href="http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/" rel="ugc">http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/</a>
</div>


yes, using LinkedServer.

http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ [http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/]

<div>
This is just a one time thing to pull all the data that is currently in an Access mdb, into the same structure that was created in SQL Express...does this still pertain? &nbsp;I don't need a link that db other than the one time to upload data.
</div>


This is just a one time thing to pull all the data that is currently in an Access mdb, into the same structure that was created in SQL Express...does this still pertain?  I don't need a link that db other than the one time to upload data.

<div>
leakim971...Thanks! &nbsp; That was exactly what I needed....
</div>


leakim971...Thanks!   That was exactly what I needed....

<div>
<div class="content wysiwyg-content">
Can I connect to an Access DB using MS SQL Server Mgmt Studio and pull the data into my SQL Express tables? &nbsp;This is the 2005 version of the software.<br />
<br />
I was just curious if I could do it from the software...
</div>
</div>


Can I connect to an Access DB using MS SQL Server Mgmt Studio and pull the data into my SQL Express tables?  This is the 2005 version of the software.

I was just curious if I could do it from the software...

Can I connect to an Access DB using MS SQL Server Mgmt Studio ?

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 Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.