I have some 2010 excel files with thousands of rows of information that I have used for years to produce our nursery online pricelist. Now we are re-organizing our nursery and pricelist and I want to convert to access files. But I have several questions.
(1) When I convert each file to access it seems impossible to get rid of the root excel files. I guess that could be a blessing because it would be easy to modify through the root excel files. But I wonder if in the long run it might some way be a problem.
(2) I would like the primary key fields to be the plants names rather than numerical code and I wonder if that will work ok.
I tried to attach sample excel files to this note but my 2010 excel files were not accepted.