[V4MD] problems with importing ascii text

[Silversoft]

Hi Ruslan,

thanks for your answer, but unfortunately that doesn't solve the
problem. Not only does using a coma mean that I can not have
any coma in the text of my fields, it doesn't prevent the returns
inside the text of my fields to warp : any straight-forward
method (like using vStudio's import option) will fail on the
first return character inside a field, because the parser will
assume that that is the end of the record, which it is not.

Indeed, exporting using an other record delimiter would also
solve my problem. 

-----Oorspronkelijk bericht-----
Van: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] Namens Ruslan Zasukhin
Verzonden: dinsdag 17 mei 2005 15:20
Aan: valentina at lists.macserve.net
Onderwerp: Re: [V4MD] problems with importing ascii text

On 5/17/05 4:16 PM, "Silversoft" <silversoft at skynet.be> wrote:

Hi Steven. 

> the source database I have to import from, is an access DB.
> 
> The problem is that there are returns in some fields, warping
> any import.

So you need to use COMA-separated format for export.
 
Unfortunate Access do not allow specify Record Delimiter for export, right?
This could simply your task.

> Besides the fact that importascii doesn't seem to work (no error
> message, but also no data in the database at all), this really
> is a problem.
> 
> I got round the fact that importascii doesn't work, by manually
> coding the import, but I can not get round this problem right now.
> 
> A possible solution would be that I could replace the return characters
> in access to an other character of my choice. Any idea how to do that?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina