| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel and SQL Server
I need to populate a column in Excel from SQL Server based on data in an
existing Excel column. For example if I have a spreadsheet with employee IDs in a column I need to go to SQL Server and populate the employee names associated with the Employee IDs into an adjoining column. I have found plenty of articles on populating a spreadsheet from SQL Server but nothing on how to use an existing column as part of the join. I appreciate any help I can get. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query SQL Server from Excel | Excel Discussion (Misc queries) | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| sql server freezes excel | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Threaded Mode
