Fermé

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 -

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 –

[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.

Thanks

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

Voir plus : export object information access, export access object information, access export object list, export access object excel, tricks excel, get blogspot, ask work, get microsoft access free, excel tricks, excel blogs, ask excel, access 2010, sql microsoft access, microsoft project price, microsoft project free, microsoft links, microsoft excel price, microsoft excel forum, microsoft access sql, sql access, price excel, object, information about, excel reports, excel report

Concernant l'employeur :
( 0 commentaires ) India

N° du projet : #1655655

7 freelance ont fait une offre moyenne de 83 $ pour ce travail

sumon355

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

54 $ USD en 2 jours
(8 Commentaires)
2.3
milamar

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)
0.0
irahmani

We have expertise in this kind of work.

180 $ USD en 2 jours
(0 Commentaires)
0.0
mostspeed

Microsoft Access Developer

80 $ USD en 5 jours
(0 Commentaires)
0.0
Tiga6317

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)
0.0
ashahin78

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

70 $ USD en 2 jours
(0 Commentaires)
0.0
TIProfi

At your service.

70 $ USD en 5 jours
(0 Commentaires)
0.0
Emir11

I need this job.

50 $ USD en 2 jours
(0 Commentaires)
0.0