I would like to convert a troublesome Excel spreadsheet with 9 sheets into a SQL Database, I have installed Visual Studio 2015 Express and I’m learning as I go. Unfortunately I haven’t made it very far, right now there are so many choices in VS 2015 Express I have no idea which one is the best one.
Facts so far:
1. Imported data from spreadsheet into SQL Express DB
2. Connected VS 2015 to DB
a. I was not sure on the import process:
i. 9 sheets in to 9 tables
ii. all sheets into one table I chose
I chose ii. and I can redo this if needed Will this work or should I change to multi tables?
Now for the 2 final questions
1. Which template do I use for multiple users accessing this at the same time (no more than 6 users.
I’ve searched the web for a flow chart on when to choose which template.
Windows Form Application or ASP.NET Web Application or ???
2. They both appear to be able to connect to SQL but is one better than the other?
Just a gentle push in the right direction and I should be able to do the rest.
Thank you in advance,