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
| Attachment | Size |
|---|---|
| DataEntryInAccess.xls | 63 KB |
| Trade_DB.mdb | 128 KB |
»
- Vishesh's blog
- Login or register to post comments
- 22279 reads
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
Genius .. Thanks