[V4MD] Import field with return

[Ruslan Zasukhin]

on 10/3/03 1:24 PM, Gregoire William at wgregoire at paris.mediagerance.com
wrote:

>> Hi Gregoire,
>> 
>> You need Export from Access into COMA separated file,
>> And import into Valentina using
>> 
>>     ImportASCII(tblCurs,the moviepath&"mythe.txt",COMA,RETURN)
>> I think this way should work.
> 
> no...since it's a memo (so text) i can have "," ;)

But Access when will do export will wrap your MEMO into qutes

    "123", "124", "this is, memo, I have comas."

You see?

 
> It seems the only way is
> ImportASCII(tblCurs,the moviepath&"mythe.txt",TAB,<unused symbol>)  (i
> personnaly use "?")

> but access doesn't let you define the records delimiters (only fields and
> text delimiters), it's why i asked if there is another way :(

Correct. Access do not allow this.
MySQL for exmaple as Valentina can do this.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------