I have info in a xls spreadsheet that I need to provide to someone as a txt file. Is there a way to convert the data into a txt file. It has fixed lengths and it is not formatting correctly when I copy and paste the fields in notepad.

Do a "Save As" then change the filetype to txt. Keep in mind, the formatting will not stay the same. Does it absolutely have to be in txt format? LIR

Long way around: Open another instance of Excel, Copy/Paste your info to the new instance of Excel Save As CSV (Comma Separated Values) MIKE http://www.skeptic.com/

The text does not have to be the same but spaces need to be between the second and last header. The txt file should have fixed lengths as well. I actually received the file as a txt, converted it to a xls so that I can import it into access. Afterwards I exported it as a xls and wanted use the results and turn it back into a txt file. Is there a better way?

Why don't you just export it from Access as a fixed width field text file? Are you making changes to the data while it is in xls format? If copying to notepad does not retain the formats, have you tried Wordpad and/or Word? In both programs Select Paste Special and select Unformatted Text MIKE http://www.skeptic.com/

I did not think I could export the file out of access as a txt file. Thanks, that just saved me a lot of time. I was trying to export the file as a xls and then convert it back to a txt file.

This is for Access 2007 but it should give you a start: http://office.microsoft.com/en-us/a... MIKE http://www.skeptic.com/