Thanks for the quick reply.I have used Porter From the Utility to export to Dos file and have used TILDA as the delimiter.Then I IMPORTED this file from ACCESS97.

Since certain fields have multivalues and are seperated by ANSI 254 character I don't know how to associate them.For example there are 3 values seperated by Ansi 254 but the next column has only 2 values seperated by ANSI 254.

If you check the dict item it will have an Mn.n in about field four, the first n is the group number, the second is the order in the group.

[email protected]

Sprezzatura Ltd

World Leaders in all things RevSoft

Kalpana ..

Using porter will, as you have found, only extract data a record at a time .. there is no 'normalization' going on.

THIS link will lead you to a simple example of reading rev file and writing to dos file.

What you need to do is create multiple files for your Associated MVs.

For example .. let's say you have an invoice file with a structure like:

invnbr

invdate

customer name

customer address

…

…

itemid (mv)

qty (mv)

In this table you would want to read all the invoices and create 2 tables. InvHeader which would contain all invoice information 0-9 and then InvDetail which would be used to write the item detail information.

InvHeader Layout

InvNbr,Customer,CustAdd ….,….,…

InvDetail Layout

InvNbr,ItemId,Qty

For each ItemId you sold you would then create a 'record' in the InvDetail file.

So using the program example linked to above .. instead of writing out the whole record simply create records that you need. 1 routine for the InvHeader information and 1 routine for the detail information.

Make sense?

[email protected] onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"

David Tod Sigafoos ~ SigSolutions

voice: 503-639-8080

View this thread on the forum...