[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]] ==== Exporting data from Advanced Revelation apps (AREV Specific) ==== === At 11 JUN 1998 07:32:25PM cyberFLUX wrote: === {{tag>"AREV Specific"}} I am currently building an application in MS Access97 that will replace parts of an AREV 2.1 application. I need to export all the user data (exluding lookup tables) and can't figure out from the installed application how to do this. I'd like to export to Excel preferably, but 123 or text delimited would do also. Anyone out there that can help? Thanks! cyberFLUX@quiknet.com ---- === At 11 JUN 1998 07:53PM DSig (SigSolutions) wrote: === There is ascii, 123 and dbase exporting. Look for the export menu(press f2 from any menu) .. then follow the options. If you have specific problems with the export post your questions dsig David Tod Sigafoos ~ SigSOlutions dsig@teleport.com cis:70302,77 voice:503-639-8080 ---- === At 12 JUN 1998 12:26PM Saul Mendoza wrote: === One piece of advice... If you are using the multivalues in the AREV tables, make sure that you normalize your tables somehow before exporting to something like .csv files.. I would write a program that normalizes into a temp table and then export from that table into your .csv files.. Saul Mendoza ---- === At 13 JUN 1998 11:21AM dwrob wrote: === The difficulty comes in mapping the files and fields in ARev to the tables and columns in Access. Once the mapping is completed there are tools,or make them, to export both data and the dictionaries into Lotus. Using Access and some VB you can read in the ARev dictionaries and use them to set-up the Access tables. Some conversions, i.e., dates, will be required in going from Arev into Access. ---- === At 13 JUN 1998 05:06PM Larry Wilson - TARDIS Systems, Inc. wrote: === Whatever you do, the best way to automate the process to make sure that you create a SCHEMA.INI file so that ACCESS can import without all of the usual prompting. (makes exporting from Access back to AREV a snap also.) For whomever didn't get my msg, my homepage is now: http:/www.tardis.cc (yes, .cc not .com) e-mail is: tardis@tardis.cc or larry@tardis.cc ---- === At 14 JUN 1998 09:51PM Jocelyn Amon wrote: === I have a free ASCII Export utility that works for G2B & Arev files. Let me know if you are interested. Jocelyn Amon finsol@ts.co.nz [[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=D4939476245849828525662000814FDB|View this thread on the forum...]]