R&R 9 with MS Access

[Carl_(Guest)]

Hi,____I^m currently designing a Macro inside MS Access to "dump" data onto our network. My problem is Access doesn^t provide an outputto format of .DBF or .DBA ____If I create a Macro with a dump file format of .xls or .rtf will R&R 9.0 be able to use it? Any other suggestions would be wonderful.____Thanks,____Carl :)

[robh_(Guest)]

Carl,____You can solve either of two ways:____1) R&R SQL Edition can read Access databases via ODBC (it can also read Excel, but not RTF.)____2) Microsoft Access can Export to DBF (File | Save As/Export), which can be read by R&R Xbase Edition.____Rob Hershfield__rob@plan-be.com__www.plan-be.com

[Scott_Jamieson_(Guest)]

I^ve been working on the same thing. Here^s the VBA a code to transfer .mdb tables to .dbf. You can run this as a macro or from the code.Sub ____XferDatabase()__DoCmd.TransferDatabase acExport, "dBASE III", "c:PRCashreg", ___ acTable, "Cutter", "Cutter2.dbf"__End Sub______