Export Object Information from Access Database to Excel

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 -







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 –

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

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.


Compétences : Administration de Bases de données, Excel, Microsoft Access

Voir plus : msysnavpaneobjectids, access export object list excel, export object information access, export access object information, access export object list, export access object excel, www excel, tricks on excel, sql query to get list of database, how to get a blogspot, how to ask for work, get microsoft access for free, excel tricks, excel blogs, ask excel, access export excel object type available, access 2010, sql microsoft access, microsoft project price, microsoft project free, microsoft links, microsoft excel price, microsoft excel forum, microsoft access sql, how to microsoft excel

Concernant l'employeur :
( 0 commentaires ) India

N° du projet : #1655655

7 freelance font une offre moyenne de $83 pour ce travail


Hello, I am very much interested to do this work.

54 $ USD en 2 jours
(8 Commentaires)

I will deliver you a full working application and a shell extention, so that you will get an instant report by right clicking on the file icon (*.mdb)

80 $ USD en 1 jour
(0 Commentaires)

We have expertise in this kind of work.

180 $ USD en 2 jours
(0 Commentaires)

Microsoft Access Developer

80 $ USD en 5 jours
(0 Commentaires)

Experience Advanced Excel and Access user. Working engineer at a Portuguese Big Company. Willing to work this out. Best regards, Tiago

150 $ USD en 2 jours
(0 Commentaires)

i can do this job please award me and give me the change to work with you

70 $ USD en 2 jours
(0 Commentaires)

At your service.

70 $ USD en 5 jours
(0 Commentaires)

I need this job.

50 $ USD en 2 jours
(0 Commentaires)