View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
philcud philcud is offline
external usenet poster
 
Posts: 34
Default set up data source of excel spreadsheet

i believe there will be too many variables (5 fields, each of whiuch
has approx 5 potential values, so this gives 5 to the power 5
combinations (3125 columns).
i would like to be able to build an sql query within a vba code as this
will be very fast and keep workbook size very small.