| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to validate excel cell against sql table query
Hi everyone
I am trying to validate entries in an Microsoft Excel 2007 workbook, against data in a Microsoft Dynamics GP 10.0 / Microsoft SQL 2005 Server database. I have a spreadsheet which contains journal entries, and I need to validate the GL Account numbers against those in the Dynamics database. Can anyone point me in the right direction? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validate Text for Pivot Table Filter | Excel Discussion (Misc queries) | |||
| Select Table and Field of Query by Cell value | Excel Programming | |||
| Selecting a cell value in VB for a Query Table | Excel Programming | |||
| Excel Vba Problem - Validate Data in cell | Excel Programming | |||
| Linking a table in Access to a table in Excel using MS Query | Excel Programming | |||
Threaded Mode
