I would like some advice. I have to do a lookup but the lookup table is a SQL server table. What would be the most efficient way to do it. Should I export the data from excel to SQL server, do a query and import back to Excel or can I do the lookup in Excel with a link to SQL server?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Lookup from SQL table
- Thread starter wikus
- Start date
Similar threads
- Solved
