Unanswered: Help - Import file into a hidden table
I have taken over a database which contains a table that is set as hidden. Recently I have been asked to create a process to import Excel files into the hidden table. I'm not having any problems with the import code but after importing a file the hidden attribute is unchecked automatically. Is there any reason for this? Is there any way to prevent this from happening? I've tried searching the forums and using Google but I haven't found any useful information.
That is also an acceptable solution but I haven't been able to track down any VBA code that would allow me to do it. I'm sure there is code to hide a table but I'm probably just not wording my searches correctly to find it. Any help you could give me in tracking down the correct VBA code would be appreciated.
I haven't ever hidden tables with code before, but, at a guess it would probably be done by modifying the Visible property of a Table object. If I get lots of time free (HAahhahaha ROFL!) I'll have a play and post the code back.
I can't say for certain why it was initially set up this way because I was not the one who created the database. However, due to the nature of this particular database, I am not the only person who needs direct access to the database structure. I was able to find the code that I needed. In case anyone else needs it, the code I used is: