If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Can I manage external connections from Access in Excel?

Thread starter excelgal2016
Start date Oct 10, 2017
Tags

access data excel external data connections table

excelgal2016

New Member

Oct 10, 2017

Hi,

I have one table in an Access DB and I use data from there for a table in Excel. Unfortunately the data includes some sensitive information (columns) which I want to leave out in that specific Excel file (I use the DB table for other purposes where I do need the sensitive data).

Is there a way to exclude specific columns when importing into Excel?

I have searched the internet but I didn't find a solution for this. Is the only solution to create a new table in the DB? (I would like to prevent this if possible). Also I don't want to just hide columns/tabs manually in Excel, as every average user would be able to un-hide them.

Thanks!

Last edited: Oct 10, 2017