getting the data from excel which is the best to use
Hi guys i get alot of information from my supplies in excel and waiting to do a little app so show me this info and import it in to a access for sql database, the thing is i have never connect to a excel doc before and i have just started using vb.net (did a really small app just for a look) i am told it is easier to do it in vb.net. what i want to know where i be doing this and how to get started
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No the Excel file come in different formats, but i think when i know hows to import one i can just do different ones for the different files, i get a new files each month and no not all my suppliers give me there files in excel some give it to me as a access file so i have got that one work with no problems
I would suggest you build your SQL datatable to represent all those different formats as one master format. And after you get the excels you can use the technique given in the link to import it.
Just be careful about different people giving it in different formats because you will have to change your logic everytime and that COULD make this app you are building not very usable.
Just be careful about different people giving it in different formats because you will have to change your logic everytime and that COULD make this app you are building not very usable.
how about a stand alone excel viewer?
Microsoft® Excel Viewer
http://www.nsf.gov/statistics/seind00/plugin/exhelp.htm
you might take a look at these too
http://www.giveawayoftheday.com/freeware/2005/11/12/select-to-excel/
http://www.giveawayoftheday.com/freeware/excel/viewer
Microsoft® Excel Viewer
http://www.nsf.gov/statistics/seind00/plugin/exhelp.htm
you might take a look at these too
http://www.giveawayoftheday.com/freeware/2005/11/12/select-to-excel/
http://www.giveawayoftheday.com/freeware/excel/viewer
ASKER
narr normal it would be a good idea but what i want to do is get the data and bring it in to my app so i am able to search through the stock
no probs just thought I'd add some choices. :)
http://support.microsoft.com/default.aspx?scid=kb%3B[LN]%3BQ316934
http://www.codeproject.com/useritems/Excel_Connectivity.asp
jpaulino