i recently made a windows application that pulls data from a mySQL Database and populates my form but when i was told to use excel instead of MySQL thats when the problems started. while setting up vb to connect to MySQL i found a few articles that explained in good enough detail how to set up vb before ever doing any coding
ie.( boot vb, start windows form project, click project/add reference, click on the COM tab and add the MySQL reference then click ok. next click data/Add new data source, chose database click next, click new connection, choose MySQL data source click continue, enter database info(server, user, password, port) click ok. then start coding connection strings and commands ( which i have no problem with)
my problem i can find all sorts of code to work with excel but i feel i need to go through the same environment set up as with MySQL but i cant figure out how to set it up i only need to read data from excel file to populate my form data ie.( text boxes, labels, datagridview, Ect...)
does anyone know how to set up the development environment to facilitate my use of excel.
or does anyone know of a better way to store and retrieve my data maybe a vb local database ( does that travel with the .exe easily???)
P.S. sorry i don't need code help today I'm pretty good with coding. if this should be posted in another forum please point me to it maybe i can get answers there but this is the best place i know of for development help( and my favorite)
This post has been edited by CodeCapition1: 12 May 2011 - 02:47 PM