On 13/06/11 10:20, Richard Parsons wrote:
Chris Walkercdw_alug@the-walker-household.co.uk wrote:
Can you elaborate on "I want the tables to be created from the names in column 3"?
This isn't my data but imagine a list of pub names in Name1, a score in Number, Brewery Name in Name2, Yes/No in Y/N, a simple address in Where and random text in Notes.
So you want multiple tables, with each tables name being the Brewery Name?
Why not have one big table, with the Brewery Name as a column?
I already have a big table of Brewery Names. I then want to be able to click on the Brewery Name and have SQL display a list of their beers.
Here I want to extract a list of the beers (plus other data) from the OO spreadsheet.