+ 0 Votes Will this help you?. Peconet Tietokoneet-217038187993258194678069903632 6 years ago From the Access help menu key on ExportExport a spreadsheet to a Microsoft Excel workbookIn the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.On the toolbar in the spreadsheet, click Export to Excel to run or switch to Excel and display the data in a workbook.NotesBecause Excel supports only 256 columns, data in columns IW through ZZ is not exported from the spreadsheet. You can copy this data to an Excel worksheet.When you export data from a spreadsheet to Excel, only the values and formulas are exported. Hyperlinks continue to work, but links that connect to other data on the Web page or other Web pages are not retained in Excel. For example, if you imported the data for the spreadsheet from a Web page or text file, when you export the data to Excel, no link is maintained to the Web page or text file.When you export some spreadsheet number formats, the data in Excel is displayed with a custom number format. For example, the Yes/no, True/false, and On/off spreadsheet formats are displayed with custom number formats in Excel. For information about custom number formats in Excel, see Excel Help. Learn about spreadsheet number formats.Please post back if you have any more problems or questions. + 0 Votes See if this helps Jacky Howe 6 years ago http://office.microsoft.com/en-us/access/HA100964371033.aspx + 0 Votes Here you go Tony Hopkinson 6 years ago http://support.microsoft.com/kb/287682is how to select random records, your problem is a bit more complex.This is ugly Create one query to get distinct provider, so now you have all 300 of 'emCreate another to do the select top five order by randomNo do a join on them by provider.That should do the top 5 by random for each of them.Don't like it at all, but it should work I think.