98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing Data from Excel
Importing Data from Excel
Resolved · Low Priority · Version 2003
Thu 10 Sep 2009, 14:31Delegate Lee said...
Lee has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course
Importing Data from Excel
What is the easiest way of importing data from Excel into Access?
Fri 11 Sep 2009, 10:40Trainer Stephen said...
RE: Importing Data from Excel
Hi Lee
Thank you for your question
There is a standard importing wizard that will do this for you
Click on file Get-Get External Data-Import.
In the resulting dialog box, select the file type as Excel Spreadsheet, and then browse to find the relevant file and click OK
The wizard will then walk you through the process, checking on data types etc. and will finish by creating an Access table based on the spreadsheet
Regards
Stephen
Thu 17 Sep 2009: Automatically marked as resolved.
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 tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
