Programaticly Save As dBASE-5 format

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Yannick Turgeon

    #1

    Programaticly Save As dBASE-5 format

    Hello all,

    I'm (still) using A97.

    I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
    format, programaticly using VBA. Is that possible? I'm currently doing
    it by hand but I'd like to automate this process.

    I looked at:

    - DoCmd.RunComman d acCmdSaveAs
    ... but it simply brings the Save As... dialog
    - DoCmd.TransferT ext
    ... but didn't find a way to export it in dBASE 5 format

    Any solution, suggestion, help would be appreciated.

    Thanks for your time.

    Yannick

  • Tom van Stiphout

    #2
    Re: Programaticly Save As dBASE-5 format

    On 24 Aug 2006 08:19:59 -0700, "Yannick Turgeon"
    <vendredi5h@gma il.comwrote:

    DoCmd.TransferD atabase

    -Tom.


    >Hello all,
    >
    >I'm (still) using A97.
    >
    >I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
    >format, programaticly using VBA. Is that possible? I'm currently doing
    >it by hand but I'd like to automate this process.
    >
    >I looked at:
    >
    >- DoCmd.RunComman d acCmdSaveAs
    ... but it simply brings the Save As... dialog
    >- DoCmd.TransferT ext
    ... but didn't find a way to export it in dBASE 5 format
    >
    >Any solution, suggestion, help would be appreciated.
    >
    >Thanks for your time.
    >
    >Yannick

    Comment

    • Yannick Turgeon

      #3
      Re: Programaticly Save As dBASE-5 format

      Thanks. Works fine! :o)

      On 24 Aug 2006 08:19:59 -0700, "Yannick Turgeon"
      <vendredi5h@gma il.comwrote:
      >
      DoCmd.TransferD atabase
      >
      -Tom.
      >
      >
      >
      Hello all,

      I'm (still) using A97.

      I'd like to save/export a table (a link to a SS2000 table) in dBASE 5
      format, programaticly using VBA. Is that possible? I'm currently doing
      it by hand but I'd like to automate this process.

      I looked at:

      - DoCmd.RunComman d acCmdSaveAs
      ... but it simply brings the Save As... dialog
      - DoCmd.TransferT ext
      ... but didn't find a way to export it in dBASE 5 format

      Any solution, suggestion, help would be appreciated.

      Thanks for your time.

      Yannick

      Comment

      Working...