excelgal2016
New Member
- Joined
- Dec 14, 2016
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
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!
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: