If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Problem to write a query result in a text file.
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 |
#3
|
|||
|
|||
Problem to write a query result in a text file.
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 |
#4
|
|||
|
|||
Problem to write a query result in a text file.
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 |
Thread Tools | |
Display Modes | |
|
|