Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

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
0
shmz
Asked:
shmz
  • 3
  • 2
1 Solution
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
shmzAuthor Commented:
How can this process be done using Query only?
0
 
sachinpatil10dCommented:
0
 
shmzAuthor Commented:
Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now