<div>
yes and you can use the Import and Export wizard in SQL 2005 to do this. <br />
<br />
<br />
start sql server management studio<br />
connect to a sql server<br />
browse to a database<br />
right click on &nbsp;a database<br />
select all task and scroll down to &quot;import data&quot;<br />
<br />
<br />
your source will be MS access.<br />
<br />

</div>


yes and you can use the Import and Export wizard in SQL 2005 to do this.


start sql server management studio
connect to a sql server
browse to a database
right click on  a database
select all task and scroll down to "import data"


your source will be MS access.



<div>
I need to make changes to some of the data within the columns and if I use Wizard, I don't have that control. am I correct?
</div>


I need to make changes to some of the data within the columns and if I use Wizard, I don't have that control. am I correct?

<div>
once u declare your source (MS Access).. you can choose to import from a table. or write a qurey to select the data you want to import.. <br />

</div>


once u declare your source (MS Access).. you can choose to import from a table. or write a qurey to select the data you want to import..


<div>
How can this process be done using Query only?
</div>


How can this process be done using Query only?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a sql server 2005 database. The data source is a combination of many tables in access database.<br />
<br />
Is it possible to write a query in SQL to extract data from a table in Access and then import some of the tables columns to SQL server?<br />
<br />
Thanks in advance
</div>
</div>


Hi,

I have a sql server 2005 database. The data source is a combination of many tables in access database.

Is it possible to write a query in SQL to extract data from a table in Access and then import some of the tables columns to SQL server?

Thanks in advance

importing data from accss database to SQL server 2005

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.