I am importing data from excel (don't know yet I am going to do that) and export it back into excel. I don't want to have users to import data using excel (due to lack of intelligence) and also it would be faster and more streamline.
I already had a complete app that did it all except I can't get it to run on any other machines. I used office PIA and that is just suck a hassle. I don't want to go down that road again. Now I have been reading posts on how to import data using OLE DB connection and it looks pretty simple.
Now what I am worried about is pushing data back into excel. How does that work? Also I came across a post that said OLD DB isn't for Excel but was originally for Access. Well how ever it falls it anyone could point me in the right directions (Except for Office PIA) I would be grateful.