This was my first time posting. I do not see how to reply to your reply. I am not using access. I am using a showcase query / showcase report writer. You can specify a pc file rather than screen prompt. You select this option from a drop down, and then browse for the file. You specify a column number, but I cannot find how to specify the sheet,