Export Object Information from Access Database to Excel (1893177)

Cancelled Posted May 24, 2012 Paid on delivery
Cancelled 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

Microsoft Access

Project ID: #2744716

About the project

31 proposals Remote project Active Aug 8, 2012

31 freelancers are bidding on average $64 for this job

Prashantskin

See private message.

$50 USD in 14 days
(477 Reviews)
7.2
sumon355

See private message.

$17 USD in 14 days
(103 Reviews)
6.2
jurassicsoftware

See private message.

$80.75 USD in 14 days
(39 Reviews)
5.2
djain01

See private message.

$300.05 USD in 14 days
(11 Reviews)
3.9
ysrahmed

See private message.

$110 USD in 14 days
(29 Reviews)
4.1
DenisSmolentsev

See private message.

$65.45 USD in 14 days
(15 Reviews)
3.5
haseebhm

See private message.

$100.3 USD in 14 days
(6 Reviews)
3.3
smb310570

See private message.

$20 USD in 14 days
(9 Reviews)
3.4
hgk

See private message.

$7 USD in 14 days
(7 Reviews)
2.7
fairchance

See private message.

$50.15 USD in 14 days
(1 Review)
2.5
ionlesan

See private message.

$30 USD in 14 days
(9 Reviews)
1.5
prashant542

See private message.

$42.5 USD in 14 days
(1 Review)
1.7
azahvw

See private message.

$40 USD in 14 days
(1 Review)
1.4
joshuafalkenvw

See private message.

$50.15 USD in 14 days
(1 Review)
0.8
cmahen

See private message.

$20.4 USD in 14 days
(0 Reviews)
0.0
royedwardsvw

See private message.

$30.6 USD in 14 days
(0 Reviews)
0.0
nawazwasif

See private message.

$15 USD in 14 days
(0 Reviews)
0.0
rajendrashetty

See private message.

$30.6 USD in 14 days
(0 Reviews)
0.0
gabusingh

See private message.

$45.05 USD in 14 days
(1 Review)
0.0
memara78

See private message.

$100.3 USD in 14 days
(0 Reviews)
0.0