I´m having trouble exporting a query from ACCESS 2010 to a .txt file. I have a field in the middle of the query, and I cannot get the data of this field unless I put it in the end of the query (as the last field). I think I must be doing something wrong, but I don´t known what may that be. Any help, please?
Problems exporting a query to a .txt file (1 Viewer)
- Thread starter jcsuarez
- Start date
A very vague explanation!
1. What is this field? Is it a calculated value for example?
2. What is the SQL of the query you're trying to export?
3. How are you exporting the query? Using code or through the Import/Export wizard?
1. What is this field? Is it a calculated value for example?
2. What is the SQL of the query you're trying to export?
3. How are you exporting the query? Using code or through the Import/Export wizard?
Thank you, vbaInet for your prompt answer.
The field name is ENTRADA, and the data are taken and selected from a Table named RESULTADOS. The field is text, and there´s only one other field that is text, which is CódECR. All other fields are numbers, but none of them are calculated in this query. They´re just selected from the Table RESULTADOS.
When I export this query to a txt file, the field ENTRADA will show up only if its located at the end of the query. The SQL command follows. The field shows nicely in ACCESS but I cannot get it into the txt file.
SELECT RESULTADOS.CódECR, RESULTADOS.PAR, RESULTADOS.Rep, RESULTADOS.TRAT, RESULTADOS.REND, RESULTADOS.ENTRADA
FROM ([ENSAYO ELEGIDO] INNER JOIN ENSAYOS ON ([ENSAYO ELEGIDO].CódECR = ENSAYOS.CódECR) AND ([ENSAYO ELEGIDO].LOCALIDAD = ENSAYOS.LOC)) INNER JOIN RESULTADOS ON ENSAYOS.CódECR = RESULTADOS.CódECR
WHERE (((RESULTADOS.TRAT)<1000))
WITH OWNERACCESS OPTION;
The field name is ENTRADA, and the data are taken and selected from a Table named RESULTADOS. The field is text, and there´s only one other field that is text, which is CódECR. All other fields are numbers, but none of them are calculated in this query. They´re just selected from the Table RESULTADOS.
When I export this query to a txt file, the field ENTRADA will show up only if its located at the end of the query. The SQL command follows. The field shows nicely in ACCESS but I cannot get it into the txt file.
SELECT RESULTADOS.CódECR, RESULTADOS.PAR, RESULTADOS.Rep, RESULTADOS.TRAT, RESULTADOS.REND, RESULTADOS.ENTRADA
FROM ([ENSAYO ELEGIDO] INNER JOIN ENSAYOS ON ([ENSAYO ELEGIDO].CódECR = ENSAYOS.CódECR) AND ([ENSAYO ELEGIDO].LOCALIDAD = ENSAYOS.LOC)) INNER JOIN RESULTADOS ON ENSAYOS.CódECR = RESULTADOS.CódECR
WHERE (((RESULTADOS.TRAT)<1000))
WITH OWNERACCESS OPTION;
In the guide, the longest text for ENTRADAS is set to 22 so ...
