Hello, I am currently trying to construct a offline plant database based on the online catalog of a website. I had some troubles with importing from HTML and in both MC ACCESS and EXCELL (both 2010), because:
- The plant names are stored in on a server and therefore are not saved to the HTML file
- The website can only be opened in Firefox and there are troubles
Website link is here if you are interested: https://www.ebben.nl/nl/treeebb/#?37...=1&37%5B2%5D=3
I am currently trying in Excel to copy the data over in a very organized way.
However I am doubting I can just simply import the data the way I have organized it now. Since from what I understand I need to have my data in a "spread sheet" and currently it is not actually a "spread sheet". Let me explain:
Currently to make it for myself easy, I have organized my information so that each worksheet is the main filter of the site, and the sub-filter of the site stands for a column. so for example: Worksheet "kroonvorm Filter", which contains the species (which are trees) plants that have a specific Crown shape type. The Species name who have those crown filter types are pasted under each column. Not every species has the same amount of plants as I kind of illustrate this as below (text is in dutch):
Zuil Ovaal Eirond Vaas Hart Piramidaal Acer campestre 'Green Column' Acer cappadocicum subsp. lobelii Acer campestre Acer capillipes Quercus petraea 'Mespilifolia' Abies concolor Acer x freemanii 'Armstrong' Acer davidii subsp. grosseri Acer campestre 'Commodore' Acer carpinifolium Tilia amurensis Abies koreana Acer x freemanii 'Armstrong Two' Acer x freemanii Acer campestre 'Elsrijk' Acer davidii 'George Forrest' Tilia henryana Abies nordmanniana Acer platanoides 'Columnare' Acer 'Norwegian Sunset' Acer campestre 'Geessink' Acer x freemanii 'Elegant' Tilia henryana var. subglabra Abies procera Acer platanoides 'Ebben's Column' Acer platanoides 'Cleveland' Acer campestre 'Huibers Elegant' Acer palmatum Acer x freemanii 'Celzam' Acer platanoides 'Olmsted' Acer platanoides 'Fairview' Acer campestre 'Queen Elizabeth' Acer palmatum 'Atropurpureum' Acer platanoides 'Eurostar'
I have a list of all the plants which is actually unfiltered. So I know how many plants I have, in the future this list will be updated with new plants.
However I am unsure if Access Can handle this, I technically can create a primary key in the unfiltered list on the plant species names, so that makes it easier to create search querries based on the species name. But since I am working with such a structure as set above, I cannot kind of set a primary key in those other tables.
How do I handle this? Do I need to split up the worksheets into more worksheets (causing my work to be for nothing) or do I need to "transpose" the table? I am kind of stuck here so help is appreciated.
Edit: I uploaded a zip file with my excel table so you guys can take a look.