Re: Access Macrosyes there is...it's not too complicated either. Basically you would use the FileSystemObject (FSO) to create, open , write-to, and close a file. I've used this to write to a CSV file which can be opened by Excel. To create a CSV file it's pretty easy...a .xls file is a little tougher, and requires excel to be installed on the server. I would suggest the .csv file because it will run a little better., , I'm assuming you know how to make csv files...delimit by commas for the feilds and line breaks for the next record., , Here is some useful info , http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=4 , , psuedo code, if file allready exists, delete it, then create it, else, create it, end if, open file with fso, connect to the db and execute SQL, while not rs.eof, write line to csv file, move next, wend, close rs, close db, close fileif you have more questions just post.., , HTH |