[V4MD] problems with importing ascii text

[Ruslan Zasukhin]

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]