[V4MD] problems with importing ascii text

[Silversoft]

These fields are indeed memo fields.
Your suggestion of mysql gave me the idea to try importing the
data on an sql server and exporting it from there. In sql server,
you can specify the characters you use for row and field delimiters,
including a vertical bar, which helps me out as a row delimiter.

It is not a nice trip, but the most important part for me is now that
I can get my data into Valentina exactly as my client provides it.
I am just thankful that he will only deliver his data 1 time, and not
for every update he does on it :s



-----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:49
Aan: valentina at lists.macserve.net; valentina-studio at lists.macserve.net
Onderwerp: Re: [V4MD] problems with importing ascii text

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

Hi Steven,
 
> 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.

In Vstudio you have just use Import?
Or you connect via ODBC ?

In the Access this is MEMO fields?
Or else ?

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

I know that this can do mySQL and Valentina.

Hmm, anybody know how to solve this problem with Access ?

-- 
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