Hi,
I am experimenting with EXCEL pivot tables to allow users access to my ACCESS DB for mass extracts of data at their request. Excel uses MS QUERY to setup the data connection which works fine into an MDB or MDE. However I was very surprised that MS QUERY allows you to update the data and...