Exporting Arev DATA even Multi Value (AREV Specific)
At 28 JUL 1999 12:14:09PM ** Mike Daniel ** wrote:
I have a way to export Arev data even the MV data and retain
all the information with out having to write a bit of code.
If you are interested please Post!!
I have performed the procedure at least 26 times with out failure!!
At 29 JUL 1999 04:19AM Heman Fan wrote:
Pls post your MV export method !
Thanks a lot !
At 29 JUL 1999 03:13PM *** Mike Daniel *** wrote:
Tools Needed
1( Excel 2( Access or Fox
Procedure:
Export your table to a *.wks file complete with MV fields.
In excel import the file and do a search for the "Y" value
and replace it with the "@" value. Save file back out as a *.wks
Enter Access/Fox and import the *.wks file and do a new Search and
replace for the "2" and replace it with " ".
do not for get to define the MV fields as Memo fields.
Also you may be able to get away with just doing a S&R the "y" to" "
in Excel. Havn't tried just yet.. But this method sure works great!
Mike Daniel [email protected]
At 30 JUL 1999 01:59PM Bizsoft Corp wrote:
We have a utility that will convert a LH file to a text file, comma delimited directly.