Page 1 of 1
R&R 9 with MS Access
Posted: Tue Aug 21, 2001 4:15 pm
by 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 :)
=> RE: R&R 9 with MS Access
Posted: Wed Aug 22, 2001 11:20 am
by 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
=> RE: R&R 9 with MS Access
Posted: Sun Aug 26, 2001 11:20 am
by 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______