i using below mentioned link import excel file in access.
the file contains data irrelevant want use (like "abc") in vba.
filepath "c:\datenbank\test_filter.xlsx" docmd.transferspreadsheet acimport, , "auto-filter", filepath, true, "a4:k"
you can't. link link.
so create simple select query linked table source, apply filter wish, , use query further processing.
Comments
Post a Comment