importing data from accss database to SQL server 2005

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
shmzAsked:
Who is Participating?
 
WizillingCommented:
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.

0
 
shmzAuthor Commented:
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?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
WizillingCommented:
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..
0
 
shmzAuthor Commented:
How can this process be done using Query only?
0
 
shmzAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.