Exporting 100 Tables

[mlr0911]

I have 100 tables that need to be exported to excel. These tables have only the table definitions which needs to be exported to an excel sheet so that I can have a sheet that tells me all the fields associated with that table. Is there a way in code to select all of the tables and have them export to excel? I don't want to use the "File", "Export" option because it will be too time consuming.

Thanks for your help.

 

[DCrake]

Simple Software Solutions

This is a time issue as you have highlighted.

Calculate the time that has elapsed from posting this question to the time a response was received - that would aculally work. To this add the time it takes to implement and test. Then finally add on thime it took to complete the procedure.

By the time you add all this up you could have done the job far quicker manually.

The easiest option is to visit each table through a query and select analyse with Excel to get the field names into Excel.

Another solution is to use tabledefs and loop though all the tables and and place each field name in every table into an arry, such as

Table Name - Field Name

Then when you have done this copy the contents of the array to a flat file and open this flat fiel up in Excel

 

[DCrake]

Simple Software Solutions

I have now created a wizard to perform this task. I have added it to the sample application section. As soon as it has been approved by the moderators it will be available.

I have also added it to my website, so if you want a copy now follow the link and go to latest news.

http://www.icraftlimited.co.uk

CodeMaster:

PS:

Have removed an image from the form which was the cause of the problem. Can now pick it up from this thread.