Record Keeping from Excel to Access

Vishesh's picture

 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


Field 1: TradeNumber ; Type: Number

Field 2: Trader ; Type: Text

Record Keeping Excel-Access

DataEntryInAccess.xls63 KB
Trade_DB.mdb128 KB

Thnx alot

This is really interesting .. i have been looking for a way to do this before also .. but failed .. Thanx for the idea :)


Genius .. Thanks