View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 4
Default obtaining data from Access

I would like to include VBA code that will import data
from an Access table. The data would come from an Access
table after one of the columns was filtered and sorted.
This can be done easily manually using 'get external
data', however using the code the macro recorder provides
yields all results from the table instead of only the ones
from the filtered column. Is there an easier way to do
this like calling upon an Access object or something?