exporting data from a view

• mazhar khan

  Newbie

  Points: 1

  More actions

  April 5, 2005 at 8:05 am

  #166534

  i have created a view in sql2000, how do u export the data in this view to ms access.

  thanks.

   

• steve alexander

  SSC Enthusiast

  Points: 108

  More actions

  April 5, 2005 at 8:46 am

  #550543

  use the export data wizard and use the query option and past the query used to create the view.

• Andy Hilliard

  Old Hand

  Points: 334

  More actions

  April 6, 2005 at 10:46 am

  #550847

  Actually, there are lots of options. This is probably a non-exhaustive list:

  • Link VIEW into Access using ODBC connection
  • Import VIEW into Access using ODBC connection (it will turn into an Access table)
  • Use Access pass-through query to "SELECT * FROM dbo.myView"
  • use the approach mention above to get the SQL for the VIEW, and use the same SQL from Access (this doesn't take advantage of any optimizing that SQL Server does with the VIEW, though, so I wouldn't recommend this)
  • use a DTS package (DataPump task) to push the data from SQL Server to Access

  There are probably lots of others...hopefully one of these works for you!

  Andy Hilliard
  Owl Creek Consulting[/url]

• iadams

  SSCommitted

  Points: 1920

  More actions

  April 6, 2005 at 11:00 am

  #550857

  Create an ODBC Connection

  In Access go to File,Get external data, select the ODBC option, select your view

  This way your Access data is in sync with the view.  This is a cheap and easy way to use Access as a reporting tool against SQLServer.

  
  -Isaiah