VB6 project: To be delivered as an executable with all vb6 source [url removed, login to view] installation program needed. Must Use ADO and a reference to mdac 2.7. Create Program which will Import products and customers to an Access 2000 database. The user will be importing from various outside spreadsheets such as Excel, Quicken, Other Access databases,To an Access 2000 database. You will assume that the user will have little software knowledge, and this should take them step by step through the process of importing their data into the Access database. You will explain how they should export their information from the other spreadsheets, so that it can be imported to the Access database. Explain if it needs to be exported first as a comma del file, and how they should set up the file. The user will be expected to correctly export their information into the correct format CSV etc, from whatever program they use. Basics: The database is structured so that a user must create a supplier first. Then categories are added, and finally products are added to the database according to category. Each product must have a cateogory. The supplierID, productID and cateoriesID are auto incremented. ID's are primary keys. *Customers is not autoincremented for ID and supports up to 5 letters number combination. CustomerID is Primary Key. User is entering CustomerID, but for this project, they should not be expected to input their own CustomerID,and the program you are creating should do this for them. The source code must be your own. Do not use source code "Found"On the net, unless it is available to use commercially and free of charge. If you use someone else's source code, explain where you obtained it , and I will need to see that it's freely available for commercial use. I will provide the coder with the database, and exact fields that are to be imported to for each table, along with the max length allowed. It would be vital to the correct functioning of the program, that the user not be allowed to import fields that have more characters than allowed by the program GUI. Some type of error message should appear which will stop the user from trying to import information that is too long for the field. You will be expected to test your program against the actual program, and download the executable which I will post for you. I will test as well. All error trapping must be done as well.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased. vb6 only, no third party controls or ActiveX components.
vb6 ref to mdac 2.7 ado