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 » Access
Access
Resolved · Low Priority · Version 2003
Tue 2 Sep 2008, 11:25Delegate Veronica said...
Veronica has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Access
Easiest way to import an excel sheet into access
Thu 11 Sep 2008, 15:32Trainer Rajeev said...
RE: access
Dear Veronica
Thank you for attending Access course. I hope you enjoyed the courses and benefited from them.
The easiest way of importing Excel sheets into Access is to choose File > Get External Data > Import...
In the dialog box please choose Microsft Excel in the file type. Locate the file that needs to be imported. Double click on it.
Follow the Import wizard step by step.
In Excel it is best to start your column headings that need to appear in a Access Table from Row 1.
The last step in the wizard asks you if you want the data in a new table or an existing table.
I hope this answers your query. Please mark the post as resolved.
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
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:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |
