View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Ron is offline
external usenet poster
 
Posts: 250
Default 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