Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maxsql
Starting Member
4 Posts |
 Posted - 2008-10-22 : 08:12:11
|
| Hi everybody,I explain here below my problem:I have some data (around 300 accounts number) in an Excel file. To them, I need to add some additional data that are stored in the Data Warehouse in a SQL Server.My idea is to connect to SQL Server directly from Excel and make a query that joins the accounts in the Excel sheet to the accounts in the account table in the DWH.I managed to connect to SQL Server creating a new Data Source and I can query directly onto SQL Server with MS Query. But the problem is that I cannot see the data in my Excel file.As well, I can open an Excel Data Source connecting to the Excel data with MS Query, but in this case I cannot see the SQL Server.In short I cannot see Excel and SQL Server data source in the same session of MS Query.I cannot import the DWH table to Excel as the cardinality of this table is too high for Excel and this would not be the quickest solution anyway.Can someone please help me?Thanks in advance for your help.Regards |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Query on data in Excel and SQL Server from Excel