Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access
Resolved · Low Priority · Version Standard
Reply Tue 12 Feb 2008, 09:54Delegate Malgorzata said...
Malgorzata has attended:
Access Intermediate course
Access Advanced course
Access
What is the best way of importing external data (for example from excel) to the table in the database but not by "copying and pasting"?
Is it possible to create a link or makro that will import the data for you by pressing a butom.
For upcoming training course dates see: Pricing & availability
RE: Access
Hi Malgorzata, Thank you for the post, In answer to your question you have the option to link to an external table or in the case of your question to an excel spreadsheet. If linking to an Excel sheet the sheet must be created as a database or as a list, this requires the rules of database to be adhered to; ie. no gap between field headings and data the data should be consistent with the heading, where a row gap or column gap appears the table will be considered to have ended etc.
Using the Menu command File, Get External Data, Change your file type to Excel Spreadsheet, choose link and navigate to your chosen file; follow the wizard options to select your choices. I hope that helps best regards Pete.
|