Local VB APP to interface with Office 365 Sharepoint 2013 site

I want to have a local app on PC's that will pop-up blank form on double-click
Allow you to fill out form
Upon Completion -
 - Save "Record" in Local Database table
 - Upload Data to Sharepoint (Office365 ~data connector) database
 - Sharepoint will start workflow that will create document(s) from data

This is what I am trying to accomplish --- My goal is to do this all without resident word / office applications (sharepoint can create document)

My first dilemma / goal is to create a simple form that will allow me to input data, and store to local Excel, Access, or text file, and also translate / Upload record to secure sharepoint table.

Can this be done....
Examples ... / recommendations

Give me simple application help, i.e. I can create a form that has four fields:

First Name
Last Name
Date

guide me / point me in right direction... I will do the research, I just know some of the folks here would have working knowledge and I won't go down a blind path that turns up empty...

Thanks for your help and direction.

John..
LVL 8
halejr1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
So as a first step, you need to decide if you want to use Winforms or WPF. Then you need to decide the filestore. You can write to and read from Excel and Access files without Office as long as these files exist and the Office Data Connector or Jet database engine is installed on the system. Come back once you have sorted this out and we will continue from there.
0
halejr1Author Commented:
CC,

thanks.. I am inclined to say WPF, because it encapsulates native windows controls, where Winforms you have to define everything.  Unless you have alternative recommendation that is my gut instinct.

The filestore may or may not be complicated....

It can be as simple as a excel spreadsheet ---

here is what I can choose from --

Excel, Access, Office365 Sharepoint (I tend to prefer this, but will require a connection)  Unless your are postulating that the data source will remain local and the sharepoint will draw data from that data source.  In that regard, I would choose the simplest route, we are talking about a form with 75 fields approximately.

Let me know if I need more detail.

Thanks.
0
CodeCruiserCommented:
Selection between Winforms and WPF would depend on your level of familiarity with both these frameworks. If you know WPF, it would suggest you use WPF.

Excel would be the simplest choice for local data store.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

halejr1Author Commented:
OK, so local Excel file and WPF it is.  Sorry was out of town on Holiday.  

So next steps --

 - Create a form that has three fields (how/ point me in right direction)
 - Create spreadsheet with three columns (do I need to define fields?)
 - program form to write values/strings to spreadsheet (VB, Visual Studio)
-  create / program data connectors between form, and Sharepoint? (help with this?)
- other stuff?
 
My assumptions:

Excel file will contain columns that represent fields, rows that represent records

Questions:
Will new records overwrite existing records, i.e. excel will just be a conduit for current data?
0
CodeCruiserCommented:
Excel can act like a database when you use JET or ACE driver. If you use Insert statement, it adds rows to exist sheet. If you use Update, it updates existing rows and so on.

This should get you started

http://www.youtube.com/watch?v=5wFA70ypJLs
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
halejr1Author Commented:
thanks for you assistance... your help got me off the ground... will keep for future reference as well
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.