How to use MS SQL Express with MS Excel

[odartey]

Hello all,
I trust you are all doing very well.
I have built an Excel database using macros and Vb and also saved the file in the binary format.
As we all know Excel just gives us a single source of data input.
My database has four data input points,but participants to the file must do entries one after
the other of which I know you are all aware.
What I seek to achieve is to allow multiple or simultaneous data input of which I am coming to this august forum to seek your help and direction.
A friend recommended I use MS SQL server 2012 to allow me use its capabilities.
I have gone through but still having challenges.
So my asking has any of you tried it and could you please share your approach.
thank you for your anticipated help
OD

 

[Chihiro]

Your question is bit too generic to get a meaningful help.

However, to give an example... I have set up following at my work.

MS SQL 2008 as back end (on dedicated server). Used MS Access as front end.

Data entry are completed by staff using MS Access front end (only require one or two development station with full install, other computers only need run-time).

Excel as reporting tool with data connection to SQL database.

Small batch file stored in network drive to update front end when modifications are made. Login/Access to front end managed through Group Policy Object and Active Directory. Connection to database handled through Universal Data Link file.

If you don't have full network admin privileges, you'd need to consult with your IT department.