Problem to write a query result in a text file.

  • Thread starter Thread starter Marco
  • Start date Start date
M

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