Let's get started.
1. Click on the main database window and select "Link Tables
2. You can do this by typing "link tables" on the File menu and select "External data", followed by.
3. Select your table
4. If it held more than one worksheet in the table Access will ask which you want to dial. There will also be asked what is the scope you want to vote. Make your selections and click the 'Next'.
5. You will nowasked if you, your table headers in Access, that the positions that are specified in your Excel spreadsheet have. If you want, then use the mouse over a cross in the box "first row contains column headings" set. Click the Next button to continue.
6. Access will now ask you what name you give your linked table. Click the 'Finish' button when you are done.
Click on the main database window and select "Tables". You should take your linked table, see theSpreadsheets - It is an Excel icon. Double-click to open the table and display. Try some of the data. Even if your table is still open, you will find the data is updated there also.
The nice thing is, you could create linked forms or queries relating to your table and have them all back into the updated spreadsheet. It might even be the graphics data in Access.
Assuming you do not want out on the table, but want all the data you think of him and create yourown table. This is easily done in Access by creating a "make-table query. I'll show this in the accompanying video.
I hope this has given you an insight into the power of the link to an Excel worksheet into MS Access. Access makes tasks like this so easily.
No comments:
Post a Comment