Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
configuring Excel to read query from sql
Hello,
I have to extract some data from SQL Server and save it in Excel files. The data is gathered with SQL queries, using some SQL User Defined Finctions and several Joins. And I have to send these files to somebody every day. The question is how do I set this and is there posibility once it is set to be saved (the configuration i mean) and reused every day so I dont have to reconfigure it all the time? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
configuring Excel to read query from sql
Hi,
Try using MS Query from within Excel. Following is how you would do it in Excel 2003: From the Menu bar select: Data Import Externla Data New Database Query Select <New Data Source In the "Select a driver for the type of database you want to access" text box, select SQL Server You wll then need to connect to your SQLServer database. Not having done much of this you should be able to either use the Query by Example or write your SQL statements. At any rate, you can save thiis query and execute it anytime you wish. For more info, you might want to Google Microsoft Query. HTH John "RioDD" wrote: Hello, I have to extract some data from SQL Server and save it in Excel files. The data is gathered with SQL queries, using some SQL User Defined Finctions and several Joins. And I have to send these files to somebody every day. The question is how do I set this and is there posibility once it is set to be saved (the configuration i mean) and reused every day so I dont have to reconfigure it all the time? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query via ODBC cannot read Integer field from FoxPro...what's w | Excel Discussion (Misc queries) | |||
Get "configuring office" every time I open excel. | Setting up and Configuration of Excel | |||
Configuring Excel 2003 to control access to Trusted Publishers | Excel Discussion (Misc queries) | |||
windows is configuring my microsoft office xp professional | Excel Discussion (Misc queries) | |||
Configuring a cell to take higher values only | Excel Discussion (Misc queries) |