I want to export my table structures into a list, but i need to see the description details as well.
Anyone ???
14 45988
I want to export my table structures into a list, but i need to see the description details as well.
Anyone ???
In order to obtain comprehensive documentation on a Table and its Fields, take these steps in sequence: - Tools
- Analyze
- Documenter
- Tables Tab
- Select Table(s)
- Options
- Select Include Options
- OK
- OK
Sorry - Should Have Mentioned Access 2007
Sorry - Should Have Mentioned Access 2007
Sorry, but I can't help you there. I'm not sure if Access 2007 has the same Documenter functionality. You could always, of course, write code to accomplish pretty much the same thing.
I wasnt aware that you could view that from within Access itself
I wasnt aware that you could view that from within Access itself
Yes, RobH - it can be done via VBA. I've written some simple code that will write the Properties of the Employees Table in Northwind.mdb, list all the Fields in the Employees Table along with their Properties and associated Values, to a file named Table Structure.txt in C:\. This code can be modified to include all Tables as well.
On Error Resume Next
DoCmd.Hourglass True - Open "C:\Table Structure.txt" For Output As #1
-
-
Dim db As DAO.Database
-
Dim tdf As DAO.TableDef
-
Dim prp As DAO.Property, fldprp As DAO.Property
-
Dim fld As DAO.Field
-
-
Set db = CurrentDb()
-
-
Set tdf = db.TableDefs("Employees")
-
-
For Each prp In tdf.Properties
-
Print #1, "|--- " & prp.Name & " ==> " & prp.Value
-
Next prp
-
Print #1, "---------------------------------------------------------"
-
For Each fld In tdf.Fields
-
Print #1, "|--- " & fld.Name & " (Field in " & tdf.Name & ")"
-
For Each fldprp In fld.Properties
-
Print #1, "|------ " & fldprp.Name & " ==> " & fldprp.Value
-
Next
-
Next
-
'Next prp
-
-
Close #1
-
-
DoCmd.Hourglass False
Contents of Table Structure.txt:
Yes, RobH - it can be done via VBA. I've written some simple code that will write the Properties of the Employees Table in Northwind.mdb, list all the Fields in the Employees Table along with their Properties and associated Values, to a file named Table Structure.txt in C:\. This code can be modified to include all Tables as well.
Why are you empty, my friend?? Is this what you were trying to post?
Kind regards,
Scott Note to all, by clicking on the Reply button you can see the whole of the last post by ADezii... I'll try to add the code he posted in another Reply window. - On Error Resume Next
-
-
DoCmd.Hourglass True
-
-
Open "C:\Table Structure.txt" For Output As #1
-
-
Dim db As DAO.Database
-
Dim tdf As DAO.TableDef
-
Dim prp As DAO.Property, fldprp As DAO.Property
-
Dim fld As DAO.Field
-
-
Set db = CurrentDb()
-
-
Set tdf = db.TableDefs("Employees")
-
-
For Each prp In tdf.Properties
-
Print #1, "|--- " & prp.Name & " ==> " & prp.Value
-
Next prp
-
Print #1, "---------------------------------------------------------"
-
For Each fld In tdf.Fields
-
Print #1, "|--- " & fld.Name & " (Field in " & tdf.Name & ")"
-
For Each fldprp In fld.Properties
-
Print #1, "|------ " & fldprp.Name & " ==> " & fldprp.Value
-
Next
-
Next
-
'Next prp
-
-
Close #1
-
-
DoCmd.Hourglass False
Contents of Table Structure.txt:
Apparently the original was too long, this code section is broken in two sections...
Regards,
Scott
Why are you empty, my friend?? Is this what you were trying to post?
Kind regards,
Scott Note to all, by clicking on the Reply button you can see the whole of the last post by ADezii... I'll try to add the code he posted in another Reply window.
Thanks a million, Scott! There's nothing quite like taking the time to arrive at a viable solution to a problem, then being unable to Post it. I'll make sure Mary gives you both a Save and an Assist on this one. (LOL). Thanks again - I'm known as the 'Man of Few Words' but this was ridiculous.
Thanks a million, Scott! There's nothing quite like taking the time to arrive at a viable solution to a problem, then being unable to Post it. I'll make sure Mary gives you both a Save and an Assist on this one. (LOL). Thanks again - I'm known as the 'Man of Few Words' but this was ridiculous.
Nothing quite so frustrating!! I've had it happen to me before without warning... Still not sure why it happens each time, but I think this one was just length.
Regards,
Scott
Nothing quite so frustrating!! I've had it happen to me before without warning... Still not sure why it happens each time, but I think this one was just length.
Regards,
Scott
I did ask Mary regarding this matter and her response is listed below. http://www.thescripts.com/forum/priv...wpm&pmid=45464
Thanks for the detail.. But... I was actually wanting something much simpler -
Something that would out put more like,
Field Name, Type, Description
EID, Number, Employee Staff ID Number
SD,Date, Employee Start Date
Something that gives me an easy ready reference to my table structures
Thanks for the detail.. But... I was actually wanting something much simpler -
Something that would out put more like,
Field Name, Type, Description
EID, Number, Employee Staff ID Number
SD,Date, Employee Start Date
Something that gives me an easy ready reference to my table structures
The code I gave you is comprehensive, and covers a lot of area. What exactly are you looking for, Table Names along with Field Names, their Types and Descriptions? The code previously listed can easily be reduced to provide that information.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Priscilla Walther |
last post by:
Hi All -
I'm a newbie to the database area, but have inherited a MySQL database to
manage along with my development duties.
We have a very large MySQL database, and the designer of the...
|
by: QWERTY |
last post by:
--------------Boundary-00=_O5I3QL80000000000000
Content-Type: Multipart/Alternative;
boundary="------------Boundary-00=_O5I3LVC0000000000000"
--------------Boundary-00=_O5I3LVC0000000000000...
|
by: Randall Sell |
last post by:
Hello all,
I am migrating a Paradox application to SQL Server. My problem is that the
existing Paradox table structure is limited. Correcting it will mean a
re-write of the application (Delphi...
|
by: Robert Stearns |
last post by:
For testing purposes I propose to add a schema (testing, how original)
and would like to copy some of my live tables to it, both structure and
data. I know I could use something like dump/restore...
|
by: ChadDiesel |
last post by:
Hello everyone. I need some advice on table structure for a new project
I've been given.
One of our customers sends us an Excel spreadsheet each week containing
their order. Currently, someone...
|
by: rAinDeEr |
last post by:
Hi,
Can any one show me a sample create table structure for storing .BMP's
and .GIF images. togther with its description.
Thanks in advance,
rAinDeEr
|
by: learning_codes |
last post by:
Hi ,
I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.
I try to create a marco...
|
by: visu |
last post by:
Hi ,
can anyone tell me how to get the complete table schema including
constraints, primary key ..etc.
through sql Query in Ms access.
We can get table information in MS SQL Server by means...
|
by: mikek12004 |
last post by:
How to copy a table (with the data) from one server to another (the two servers are in different PCs)? Basically if I could move the data to a txt file inthe form of the insert command (like the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |