Importing Excel Tab Delimited File (AREV Specific) [Revelation On-Line Wiki]

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

At 31 JAN 2000 02:49:10AM Pete wrote:

AREV Specific

I'm trying to import a tab delimited text file from Excel 97 into AREV version 1.15. The import process creates records in the import AREV file but there are no field values within each record.

Can anyone tell me how they manage to import a tab delimited text file into AREV version 1.15?

Here is my Import ASCII specification:

Process=REC1FIELD1, =REC1FIELD2 , =REC1FIELD3

Key 1 =REC2FIELD1, =REC2FIELD2 , =REC2FIELD3

Key 2 =REC3FIELD1, =REC3FIELD2 , =REC3FIELD3

But instead, I see:

Key 0=Null Record

Key 1=Null Record

Key 2=Null Record

At 31 JAN 2000 03:02AM PETE wrote:

Sorry guys,please do not respond, because I found out the problem. I forgot to specify the dictionary items in the import specification. The dictionary items should not have a start byte and no length because I am using a delimiter in the import process.

I was able to see the data after I did this and re-run the import process using F9.

View this thread on the forum...