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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to validate excel cell against sql table query
Hi Ron,
Yes I could do it but it would get very techicnal. Suggestion 1 Open a new worksheet in excel set up get external data from external source. Then write a query (View) in sql and then access this from excel to your new sheet. Then where the data is located then you could do a Vlookup to check against the Dynamics database. Regards Trev B "Ron" wrote: 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 |
Reply |
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 |