View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clint[_2_] Clint[_2_] is offline
external usenet poster
 
Posts: 3
Default Retrieving data with SQL and ODBC selected by key values in cells

Can someone point me to a source of information that will jump start me on using SQL and ODBC to retrieve data from an external data source selected by key values that are in a column of cells? I am writing some VBA code to automate a number of steps for clerical users and would like to save them data entry by retrieving data items associated with key value(s) entered. I'm reasonably up to speed with VBA in general - just need a jump start for these methods I haven't used before.