Link Excel Database to Sql Server Database for transfer of information(repost)
$100-500 USD
Cancelled
Posted over 17 years ago
$100-500 USD
Paid on delivery
We have an eCommerce site (sells apparel). We also have an Excel spreadsheet which contains our current list of inventory. Currently what we do is:
1. Create a purchase order (2 shirts, 2 pants etc) in the spreadsheet. We then email this to a supplier.
2. When we receive the order we enter the inventory into the spreadsheet (shirt size, colors etc).
3. We then login to the eCommerce website (admin section) and enter the inventory.
4. When sales are made from the website we make a manual adjustment of the spreadsheet to reflect this.
5. We write details of each sale in the Excel spreadsheet (Item, quantity, shipping info etc).
There is a lot of duplication in this process, with the same data being typed several times. We require a solution (Excel based or otherwise) which would automate this process:
1. We would create the purchase order.
2. When we receive the order we can transfer the items received to the inventory section of the spreadsheet.
3. Upload the inventory to the website database (Sql Server database, the fields in the Sql Server database match back to the fields in the Excel spreadsheet).
4. Download sales details back to the Excel database.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Saturday Dec 16, 2006 9:05:33 AM:
Hello,
Sorry, the database is actually SQL server at this point.
## Platform
MS Windows 2000+
Microsoft Office 2000+ if your solution is Excel based