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 training london - Merging excel into database
access training london - Merging excel into database
Resolved · Low Priority · Version Standard
Wed 28 Feb 2007, 09:50Delegate Corinne said...
Corinne has attended:
Access Introduction course
Excel Intermediate course
Merging excel into database
How do you merge excel data into a database?
Mon 5 Mar 2007, 13:09Trainer Tracy said...
RE: Merging excel into database
Hi Corinne,
Thanks for the question,
You can import data from excel into Access by choosing the option "Create a table by entering data, double click on that so you get an empty page.
Then go File > Get external data > Import data, then a browse option comes up for you to find your spreadsheet and you follow the wizard thereafter.
Good luck
Tracy
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:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
