I'm getting mightily p'ed off with this... [img]images/smilies/mad.gif[/img]

I've got a report in MS Access 97 that I need to output to a text file. I can create the text file BUT it seems to be inserting random carriage returns into the file so that it's making blank lines. I've jiggled around with the format of the report (re-size font, remove headers/footers etc, re-size fields). This changes where the blank lines are in the output but I can not get rid of them completely.

It looks OK when I preview the data, but when I use the Save As/Export option to an external file and specify the TXT file format it gives me something like this...


0266-21672NS 4 8.50

0266-21672NS 4 8.50

0266-21672NS 4 8.50
0266-21672NS 4 8.50

0266-21672NS 4 8.50
0266-21672NS 4 14.00

0266-21672NS 6 8.50

0266-21672NS 6 14.00
0266-21672NS 6 14.00

0266-21672NS 8 8.50

0266-21672NS 12 8.50
0266-21672NS 12 14.00

0266-21672NS 2 8.50
0266-21672NS 2 14.00



I can not export to Excel as it's greater than the row limit in Excel97.

Alternatively, If I can export this data into a table I should be able to export from there, but there's no option in Access97 to export data from a report to a table (or none that I've found).

Can anyone offer any help?

Thanks.




[Edited by Nimbus - 5/23/2002 10:32:37 AM]

 

MS Knowledgebase Article

hth

 

Thanks Crispin,

I tried several heights but they all gave me some blank lines...


However

I read a couple of other aritcles and found something that works much better. I'm using a select query to contacenate data (something the help in Access didn't tell me I could do ) and exporting this. There's no blank lines now and the export is much quicker.

Thanks for pointing me in the right direction