If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DB Documenter
Hi.
In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
#2
|
|||
|
|||
DB Documenter
Is Tools Analyze Documenter what you seek? It generates a report, or
you can export the data to a variety of formats. "FBxiii" wrote in message ... Hi. In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
#3
|
|||
|
|||
DB Documenter
Hi.
Yes, it is the Tools Analyze Documenter I am trying to use. In Access 97 there was the option to save the report as a table, but it does not seem to be there. I have tried exporting to Excel, but it didnt give me the tables in the Output!! Thanx, Steve. "BruceM" wrote: Is Tools Analyze Documenter what you seek? It generates a report, or you can export the data to a variety of formats. "FBxiii" wrote in message ... Hi. In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
#4
|
|||
|
|||
DB Documenter
Documenter actually creates a table in a wizard MDT file that you can link to
and query. There is an article on how to use the results of the documenter at http://www.access.hookom.net/documenter/ -- Duane Hookom Microsoft Access MVP "FBxiii" wrote: Hi. Yes, it is the Tools Analyze Documenter I am trying to use. In Access 97 there was the option to save the report as a table, but it does not seem to be there. I have tried exporting to Excel, but it didnt give me the tables in the Output!! Thanx, Steve. "BruceM" wrote: Is Tools Analyze Documenter what you seek? It generates a report, or you can export the data to a variety of formats. "FBxiii" wrote in message ... Hi. In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
#5
|
|||
|
|||
DB Documenter
I know that you can export to an existing table in a mdb file, but I don't
know how to go about that. If I save the documenter output it is to a snapshot file. Exporting to something like a spreadsheet or table will probably be clumsy since the export format relies so heavily on spaces rather than tabs and such. When I typed "microsoft public access" documenter export access table into Google Groups I got a number of hits. Jeff Conrad's reply in the second one may be helpful: http://groups.google.com/group/micro...d40a8274afe22? I mention that it is the second one in case the link doesn't work. "FBxiii" wrote in message ... Hi. Yes, it is the Tools Analyze Documenter I am trying to use. In Access 97 there was the option to save the report as a table, but it does not seem to be there. I have tried exporting to Excel, but it didnt give me the tables in the Output!! Thanx, Steve. "BruceM" wrote: Is Tools Analyze Documenter what you seek? It generates a report, or you can export the data to a variety of formats. "FBxiii" wrote in message ... Hi. In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
#6
|
|||
|
|||
DB Documenter
Thats Spot on!
Its amazing how MS drop such useful features, in 'improved' versions of their applications. "Duane Hookom" wrote: Documenter actually creates a table in a wizard MDT file that you can link to and query. There is an article on how to use the results of the documenter at http://www.access.hookom.net/documenter/ -- Duane Hookom Microsoft Access MVP "FBxiii" wrote: Hi. Yes, it is the Tools Analyze Documenter I am trying to use. In Access 97 there was the option to save the report as a table, but it does not seem to be there. I have tried exporting to Excel, but it didnt give me the tables in the Output!! Thanx, Steve. "BruceM" wrote: Is Tools Analyze Documenter what you seek? It generates a report, or you can export the data to a variety of formats. "FBxiii" wrote in message ... Hi. In Access 97 you could run the DB Documenter tool and then save the results as an Object Definition table for reporting on. I cannot seem to do this in Access 2003. Can this still be done? Cheers, Steve. |
Thread Tools | |
Display Modes | |
|
|