Problem to write a query result in a text file.

[Marco]

Hello.

I have an access database that write several queries result into several
text files. It's one query per text file.

In a particular one it's happening a strange thing. Access is inserting two
records into one column.

but it only makes that in ane record and for no particular reason.

But the most strange thing is that if I run the query as a select query it
show me everything ok.

I need this:
2402006|2006-04-17||N|||

and is happening me this:
2412006|2006-02452006|2006-04-17||N|||

"|" is the delimiter

What can be happening?

Regards,
Marco

 

[Marco]

Hello.

The database and table I think they are ok.

It's a AS400 DB2 database.

But you gave me an ideia.

I'll create a access table very restritic and the export to txt and only
after I'll export the data.

I'll let you know the result.

Thanks,
Marco

 

[Marco]

Hello.

I tried something that I think it worked.


I create a manually local table (not a make table querie) and I insert the
data inside.

then I create a macro to transfer text to text file and I think it's working.

Thanks for the ideia.

Regards,
Marco