importing data from accss database to SQL server 2005


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

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?
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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..
shmzAuthor Commented:
How can this process be done using Query only?
shmzAuthor Commented:
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.