exporting data from a view

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

steve alexander SSC Enthusiast Points: 108 More actions · Answer 1

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

Andy Hilliard Old Hand Points: 344 More actions · Answer 2

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: 1970 More actions · Answer 3

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