Laura has attended:
Multiple applications course
Microsoft Access
Is there a simple way to add information to access via spreadheets etc either adding new data or adding to existing data
RE: Microsoft Access
Hi Laura, Thank you for your post, in answer to your question, if your requirement is to add/edit information in ie an Excel Worksheet, and have this related to your Access Database, why not link the Excel Worksheet to your Database, in this case any subsequent changes made in the Worksheet will be reflected in the Access Table. Before you link your Worksheet you must ensure that it is in a format that can be successfully read by Access, ie no fancy heading lines etc. The Field names should be in row 1 with the data in row 2 and down, this way when you link you are not including extraneous rows of non useable data.
Therefore to link the Excel Worsheet to Access and have Access view it as a Table follow these steps;
1. Prepare your Excel Worksheet, save and close it.
2. In Access; In Datasheet view From the Menu command File>Get External Data>Link Tables, in the dialog box, change the Files of Type option to Microsoft Excel, Navigate to your chosen Workbook, In the Link Spreadsheet Wizard choose the Worksheet you wish to use, Follow the steps in the wizard, When you have completed the wizard, you will see an icon for your Link, the Table can be used in the same way that you would use any table, however any new changes made in the underlying Excel spreadsheet will be reflected in your Access Database each time you open it afresh. I hope that helps, if so please click the Resolved link, best regards Pete.