?
Solved

Extracting Access column names to Excel

Posted on 2004-08-13
4
Medium Priority
?
371 Views
Last Modified: 2012-06-27

Is there a way by which I can copy the names of columns from Access into an Excel file. What i basically need to do is review several columns in several tables in one DB. If I could get a list of all these columns into Excel it wouldreally make things easy for me.

Is there a quick way to do this?

Thanks,
KM
0
Comment
Question by:KalluMama
4 Comments
 
LVL 1

Accepted Solution

by:
adsmk2003 earned 2000 total points
ID: 11793993
yes, you could create a copy of the table with the columns (within access) and then run a delete query on that table to empty it.  Then you could export that table to an excel spreadsheet....
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 11794012
0
 
LVL 5

Expert Comment

by:Emanon_Consulting
ID: 11794115
If you're looking for a quick and dirty way to get the names of the fields in excel then what I might suggest is...
Create a query for the table(s) you want in excel like this

SELECT tblValue.ValueID, tblValue.FName, tblValue.LName, tblValue.DollarValue
FROM tblValue
WHERE (((tblValue.ValueID) Is Null));

In the ID field for the table all you need to do is place Is Null in the Criteria.  This will display all results where there is NO DATA in the tables primary key field meaning no records/data will be displayed.

Then just use the Office Links to Analyze it with MS Excel.  This is found under Tools then Office Links.


Hope that works for you
Cheers
Michael
0
 
LVL 4

Expert Comment

by:Colonel32
ID: 11794652
This will drop all the tables and all their fields into your debug window. You can simply copy that into any other medium you wish to - Excel included :)

For Each tbl In CurrentDb.TableDefs

    Debug.Print tbl.Name
    Debug.Print "---------"
    For Each fld In tbl.Fields
        Debug.Print fld.Name
    Next fld
    Debug.Print vbLf
   
Next tbl
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question