Export Object Information from Access Database to Excel (1893177)
$30-5000 USD
Paid on delivery
I have got a few access databases which have got a lot of tables and queries etc. inside them.
I am looking for an easy way by which I can get the following information from my database files into excel sheets -
## Deliverables
I have got a few access databases which have got a lot of tables and queries etc. inside them.
I am looking for an easy way by which I can get the following information from my database files into excel sheets -
Part 1 -
This will show a list of all the 6 objects present inside a database -
** ** Tables
** ** Queries
** ** Forms
** ** Reports
** ** Macros
** ** Modules
One column of the excel sheet will tell the Object Name and another column will tell the Object Type, whether it is a table or report etc. "This type of information is available inside this hidden table within each access database - MsysNavPaneObjectIDs."
Part 2 -
In another sheet, I want further information about the tables and queries.
Tables - **It** should show the list of all the Fields / Columns present within that table.
Queries - It should show the Query Names in one column and the SLQ statements of those queries in another column.
** **
The project is not difficult at all. Moreover some good information about similar work is available on these links given below, which will give clear hints about how this type of work could be done -
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
The bidders with the low price bids would be interviewed first.
Feel free to ask for more information if you have any doubts about this project.
Thanks
Project ID: #2744716