I am trying to import a record from an Access table and for that record to be randomly chosen.
i.e. I have an Access table with 10 records (all plain text lines). I want these records to appear in the Excel column in a random order.
I can generate a random number (1-10) in each cell and I know how to make a data connection between cell and database, but how can I specify which record (by ID key) should be imported to which cell? At the moment it is just importing the whole table into 10 columns.

Hope that is clear enough!
Cheers for help.