Problem to write a query result in a text file.

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

Problem could be:

1 - source doesn't have proper field delimiters and end of record delimiter
on one of the records - which spills into the next record
2 - source is corrupt
3 - select query and output query aren't as identical as thought

Chris
Microsoft MVP


Marco wrote:
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

--
Message posted via http://www.accessmonster.com

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









"Chris O'C via AccessMonster.com" wrote:

Problem could be:

1 - source doesn't have proper field delimiters and end of record delimiter
on one of the records - which spills into the next record
2 - source is corrupt
3 - select query and output query aren't as identical as thought

Chris
Microsoft MVP


Marco wrote:
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

--
Message posted via http://www.accessmonster.com

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



"Chris O'C via AccessMonster.com" wrote:

Problem could be:

1 - source doesn't have proper field delimiters and end of record delimiter
on one of the records - which spills into the next record
2 - source is corrupt
3 - select query and output query aren't as identical as thought

Chris
Microsoft MVP


Marco wrote:
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

--
Message posted via http://www.accessmonster.com