RECOMMENDED BEST DATABASE SOFTWARE

I wish to transfer around 320 Excel files onto a database system. The total size of the file folder concerned is 600MB. If I can do this successfully, there will be other information that I wish to transfer in the same way.

Favourite option is to install Office 365 which includes Access 2016. This seems the most logical but are there limits on file size and lines of information that can be entered ? As a guide, the Excel spreadsheets have up to 6,000 lines of information each.

If Access will present problems, are there better database products available - or will perform better and quicker than Access ?

I am sorry if the question is a little basic compared with most questions on the forum but some guidance would be much valued.

6000 rows per table shouldn't be an issue for access. The limitations of access can be seen at https://support.office.com/en-us/ar...ications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c (things like max file size, table siz, etc)

If you want a more featured system something like Postgres is pretty good.

Cromewell said:

6000 rows per table shouldn't be an issue for access. The limitations of access can be seen at https://support.office.com/en-us/ar...ications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c (things like max file size, table siz, etc)

If you want a more featured system something like Postgres is pretty good.

Click to expand...

I just did coursework using Postgres for uni and I loved it.

You can use python (meh) quickly too with it.

PgAdmin3 ships with Postgresql, if you want a GUI.

If you want to have a look, its on my github. https://github.com/SpriteMidr/UGCMP_CMP_4010B_CW ... see if you fancy working with a system like that.

Thanks very much for the responses. I will be going for Access as a "starter" system but the Postgres option is one for future consideration.

Once again, thanks for your time in replying.

Access is a good candidate. You will sort your database in a second vs minutes with Excel.
Had this issue before years ago.

tremmor said:

Access is a good candidate. You will sort your database in a second vs minutes with Excel.
Had this issue before years ago.

Click to expand...

I guess it really depends on whether the OP wants to have multiple systems accessing the database at once in the future. I am guessing not, and if so, yeah. Access will be decent. Otherwise I would suggest Postgres to be fair.



PGAdminIII is pretty fun to work with once you get the hang of SEQUEL.

This was part of the coursework. I had to connect over terminal gateway to access my schema again

tremmor said:

Access is a good candidate. You will sort your database in a second vs minutes with Excel.
Had this issue before years ago.

Click to expand...

Thank you for the response, it is much appreciated.

I have recently installed the Office 365 version of Microsoft Office 2016, including Acess.

Curiously, I am now having a problem with my Excel files. They open but, when I try to use them, the file is "not responding" and the table becomes solid black!

What error is it showing exactly? Is it like this:



or does it try to recover, or what?

(Sorry for the basic question :3)

Apologies for the delay in replying.

No actual error is showing but the screen remains black for a long time and I have to resort to shutting down the computer with Excel still "not responding".

I thought there might be something new in the "make-up" of Office 2016 to make this happen but I am also getting, on some of the files, Norton reporting it has "blocked intrusions".

wallace said:

Apologies for the delay in replying.

No actual error is showing but the screen remains black for a long time and I have to resort to shutting down the computer with Excel still "not responding".

I thought there might be something new in the "make-up" of Office 2016 to make this happen but I am also getting, on some of the files, Norton reporting it has "blocked intrusions".

Click to expand...

Step 1. Get rid of Norton. It is a pox. I would not be surprised if that is not causing your issues.

When Vista came out, Norton had a nice glitch where it would repeatedly open and close my disk tray until I either removed it totally or registered a subscription with them.

I have had Norton for quite a while and was using it well before this problem started occurring. I still think it has something to do with differences in the Office 2016 set up.

Have you tried repairing office?

Programs and Features > Office16 or whatever it is called > repair?

Do a full "online" repair. Just keep your product key handy as you will need it.

I have been having weird issues with Visio 2013 and OneNote recently. Wondering whether Windows 10 is anything to do with it.