Hi

I have tried to link an Excel file, which has been filtered from 198 values to 144 values, to an Access 2010 query. Access links to the file but with all 198 values.
I understand that Access ignores hidden/filtered values. Is there a way around this problem?

Thanks

Al Charbonneau