Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Field Data Types (2003)

    Hi All

    Is there a way to export the field data type details to excel?

    I'm in the process of mapping data from one database table to another but I need to compare the field types,lengths etc. side by side in something like excel to work out where my mapping errors are coming from.

    Is this possible?

    Kind regards
    Hayden

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Field Data Types (2003)

    Do you want to export the Tables design to Excel ? I'm afraid that's not possible.
    You can compare two databases with the program Total Access Detective, but it is not cheap.
    Francois

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Exporting Field Data Types (2003)

    Hayden,

    Try the following.

    Select Tools Analyze Documenter
    Select Tables Tab and Select the tables you need data on
    Select Options, Include for tables selections are unchecked, Include for Fields middle radio button, Include for Indexes as needed and press OK
    Select OK to generate the report
    With the report open, Select File Export, Choose Excel
    This is not pretty but will get the data to excel.

    HTH
    Regards,

    Gary
    (It's been a while!)

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Field Data Types (2003)

    Thanks for this Gary

    It been a big help

  5. #5
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Field Data Types (2003)

    Hi Francois

    Thanks for the link, it may be useful in the future

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •