Programaticly Save As dBASE-5 format

Giganews Newsgroups
Subject: Programaticly Save As dBASE-5 format
Posted by:  Yannick Turgeon (vendredi…
Date: 24 Aug 2006

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.RunCommand acCmdSaveAs
        ... but it simply brings the Save As... dialog
- DoCmd.TransferText
        ... but didn't find a way to export it in dBASE 5 format

Any solution, suggestion, help would be appreciated.

Thanks for your time.