This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am currently attempting to connect to a Sage Intact database via a third party driver C Data.
My goal is to test that I am able to actually see the data for each table that exists in the Sage Intact source. However, some tables, for whatever reason, show a permission error or say invalid object type. There are roughly couple hundred tables and for me to create couple hundred input's is just not a good idea.
Anyone have any good ideas as for the easiest and best way for me to do this? Preferably if you can show me? I was thinking a macro could do it, but honestly I wouldn't know how to do that.