Engineer 3 Report post Posted November 6, 2021 Good evening, Is there anyone here who is very familiar with MS Access please ? I keep a record of my masonic activities in a spreadsheet which currently runs to about 5-600 rows. I want to replace this with a database which has a common data entry form and then have the ability to run reports; either pre defined or ad-hoc. I seem to have created a db with various tables for lodges, ranks etc but I am having the Devil's own job of exporting data from the spreadsheet into the db. It would be useful to be able to talk this through with someone knowledgeable. All, of the data is text, no graphics nor video. To be clear, this isn't a commercial project, it is for my own use. Thanks in advance, Eng. Quote Share this post Link to post Share on other sites
Sentience 64 Report post Posted November 8, 2021 You need to be very careful if you are the creator of a database that contains the details of others, especially without their knowledge, irrespective of whether it is for personal or commercial use. I recommend some serious reading of the law around GDPR if you're UK based. Quote Share this post Link to post Share on other sites
Engineer 3 Report post Posted November 8, 2021 11 minutes ago, Sentience said: You need to be very careful if you are the creator of a database that contains the details of others, especially without their knowledge, irrespective of whether it is for personal or commercial use. I recommend some serious reading of the law around GDPR if you're UK based. As I said this is a record of MY activities but thank you for your concern. Quote Share this post Link to post Share on other sites
Sentience 64 Report post Posted November 10, 2021 On 06/11/2021 at 17:44, Engineer said: Good evening, Is there anyone here who is very familiar with MS Access please ? I keep a record of my masonic activities in a spreadsheet which currently runs to about 5-600 rows. I want to replace this with a database which has a common data entry form and then have the ability to run reports; either pre defined or ad-hoc. I seem to have created a db with various tables for lodges, ranks etc but I am having the Devil's own job of exporting data from the spreadsheet into the db. It would be useful to be able to talk this through with someone knowledgeable. All, of the data is text, no graphics nor video. To be clear, this isn't a commercial project, it is for my own use. Thanks in advance, Eng. Okay, but the bit in red is a little confusing. Quote Share this post Link to post Share on other sites
Engineer 3 Report post Posted November 10, 2021 5 hours ago, Sentience said: Okay, but the bit in red is a little confusing. Confusing me as well, as I do not recall changing the font ! Eng. Quote Share this post Link to post Share on other sites
Sontaran 90 Report post Posted November 12, 2021 On 10/11/2021 at 14:26, Sentience said: Okay, but the bit in red is a little confusing. I read that as being the various lodges/chapters/preceptories/tabernacles/etc he belonged to - Quote Share this post Link to post Share on other sites
Sentience 64 Report post Posted November 13, 2021 16 hours ago, Sontaran said: I read that as being the various lodges/chapters/preceptories/tabernacles/etc he belonged to - I read it as the details of the various ranks and offices within those Lodges. Call it my wary retired plod brain. 1 Quote Share this post Link to post Share on other sites
Engineer 3 Report post Posted November 14, 2021 On 13/11/2021 at 13:09, Sentience said: I read it as the details of the various ranks and offices within those Lodges. Call it my wary retired plod brain. Both. The current spreadsheet and proposed db are a record of activities. Still confused as to how the font changed colour. Anyhow, no offers of help, public or otherwise, so I will need to plough through it and see if I can identify the problem with importing the csv version of the spreadsheet into the db or just manually enter the back records. Hey ho. Eng. Quote Share this post Link to post Share on other sites
Sontaran 90 Report post Posted November 15, 2021 (edited) 18 hours ago, Engineer said: BStill confused as to how the font changed colour. I doubt it did - it's easy enough to change font/colour when replying to a post (as I've done .. using 'bold' and the colour picker) What's actually the problem? (retired s/w eng here...) PM if necessary Edited November 15, 2021 by Sontaran Quote Share this post Link to post Share on other sites
Engineer 3 Report post Posted November 15, 2021 2 hours ago, Sontaran said: I doubt it did - it's easy enough to change font/colour when replying to a post (as I've done .. using 'bold' and the colour picker) What's actually the problem? (retired s/w eng here...) PM if necessary Thanks. To save boring you with a lot of detail at this point how are you with MS Access please ? I know a lot of "pros" consider it the work of the Devil and avoid it like plague. Regards, Eng. Quote Share this post Link to post Share on other sites
mindmagic 40 Report post Posted November 16, 2021 I've never used database software, so I can't help directly, but if you're not keen on Access you could try Base, the free alternative included as part of LibreOffice. https://www.libreoffice.org/discover/base/ Quote Share this post Link to post Share on other sites
Sontaran 90 Report post Posted November 17, 2021 On 15/11/2021 at 15:42, Engineer said: Thanks. To save boring you with a lot of detail at this point how are you with MS Access please ? I know a lot of "pros" consider it the work of the Devil and avoid it like plague. Regards, Eng. Don't use Base (LO) unless you are really sure what you're doing. Access is ok for what you want IMO. And as far as the 'pro' side of things are concerned, my particular expertise is on embedded software (eg GPS), military or aviation (although it's all 12 years out of date now). What's the problem you're having? - I can't guarantee I know the answer, but unless you ask the question ... Quote Share this post Link to post Share on other sites
Engineer 3 Report post Posted November 18, 2021 I have approx 500 rows of csv data to import into a db which mainly consists of tables e.g. a table for the various units, a table for offices, a table for rank etc. I attempt to import the csv data using the Access external data import wizard and get a total failure to import. I can PM you and then send a sample of the csv and the db files. Regards, Eng. Quote Share this post Link to post Share on other sites
Sontaran 90 Report post Posted November 19, 2021 (edited) 19 hours ago, Engineer said: I have approx 500 rows of csv data to import into a db which mainly consists of tables e.g. a table for the various units, a table for offices, a table for rank etc. I attempt to import the csv data using the Access external data import wizard and get a total failure to import. I can PM you and then send a sample of the csv and the db files. Regards, Eng. By all means do so. What version of Office? - last version I have is 2007, but you should be able to save in that format and then 'update' it if I manage to fix whatever is wrong. Edited November 19, 2021 by Sontaran Quote Share this post Link to post Share on other sites
Sontaran 90 Report post Posted December 29, 2021 On 18/11/2021 at 19:32, Engineer said: I have approx 500 rows of csv data to import into a db which mainly consists of tables e.g. a table for the various units, a table for offices, a table for rank etc. I attempt to import the csv data using the Access external data import wizard and get a total failure to import. I can PM you and then send a sample of the csv and the db files. Regards, Eng. Do you still need this? (nothing received ...) Quote Share this post Link to post Share on other sites
