getting table structure out of MS-Access

From: Bart Lateur (bart.lateur_at_pandora.be)
Date: 03/25/04

  • Next message: David N Murray: "Re: getting table structure out of MS-Access" 
    To: dbi-users@perl.org
Date: Thu, 25 Mar 2004 04:20:58 +0100

    I'd like to automate exporting data out of an existing Access database,
    using DBI/DBD::ODBC, I guess. I need a proper description of each column
    in a table, in order to reconstruct a complete CREATE TABLE statement.

    My guess is that the func() method in DBD::ODBC could help. I've
    experimented a little with

            $sth->func($col, 'DescribeCol')

    but the results don't mean too much to me. I'm stuck. Help? 

    -- 
	Bart.
  • Next message: David N Murray: "Re: getting table structure out of MS-Access"

    Relevant Pages

    • IIS failure when Access DB linked to outside tables
      ... I have an ASP application that relies on an Access database with linked ... The application works fine on the internet (the site functions ... or change the links prior to posting a copy ... I'd prefer to test it with the proper ...
      (microsoft.public.dotnet.framework.adonet)
    • Where to post...NEED FREELANCER
      ... Sorry if I'm posting to the wrong ng, but I need a freelancer to bid on a ... Please direct me to the proper ng if this is not the correct one. ... I have an access database I need to be posted on a web server so it can be ...
      (microsoft.public.frontpage)
    • Re: Help on important DAta security choice ?
      ... Certainly not the ms Access database, however did you ask your question in ... this newsgroup ... That one looks more proper for your question (not that you are not welcome ... Cor ...
      (microsoft.public.dotnet.general)