Record Keeping from Excel to Access
This is a small utility to show how to use Access as a backend to the Excel interface. Using this utility you can enter data in Excel which is then saved in Access. The use of Access makes the data sharing easier.
Access Database Details used in the example (Create an access database with same details):
Database name: Trade_DB
Table Name: TRADING_DETAILS
Field 1: TradeNumber ; Type: Number
Field 2: Trader ; Type: Text