469,648 Members | 1,421 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

how to use a SQL view as a data source for Excel file

I originally posted this problem on the SQL Server forum.
I received a reply from a definite non-newbie instructing me to post my question to this Access forum. SO, here goes...
Hello, all!
I'm a "newbie" to this forum and I need help. There is a "view" in a SQL Server 7 database that contains all the data I need.

I want to create an Excel file (version Excel 2000). I want the file to open the view and refresh the data every time. (The view pulls records for the past 3 months.)

I tried the Excel menu option "Data | Get External Data | New Database Query" to select the view from the list of database objects. A message appeared and the Excel spreadsheet populated with records. I then saved the .xls file.

PROBLEM: The data isn't refreshed everytime I open the .xls file. It still contains "old" data.

What do I need to do to let Excel know to re-pull the view every time the .xls file is opened? (The versions of SQL Server and Excel are "old", but I can't do anything about that at this time.)

Any ideas? (Think of simple things--I have a new computer and the IT dept. may not have installed all the add-ins, etc. that I need for this task.)
Apr 17 '07 #1
1 1602
14,534 Expert Mod 8TB
In Excel under the data menu there is a refresh data option.
Apr 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Chris | last post: by
1 post views Thread by Dianna K | last post: by
reply views Thread by Tim Brooks | last post: by
9 posts views Thread by harborboy76 | last post: by
8 posts views Thread by Bruce_Stough | last post: by
6 posts views Thread by slinky | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.