98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Low Priority · Version 2003
Arabella has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access
How to transfer information on a number of excel spreadsheets into an exsiting access database when the database is listed in employee order
RE: Access
Hi Arabella,
Thank you for your post, in answer to your question, I would follow the Get External Data operation; This allows you to Import or to Link your Excel spreadsheets into your database, so long as your Excel spreadsheet matches the Access table (All fields including ID field) you should be able to import to an existing table, if not you might have to import the spreadsheet to a new separate table, manipulate your data until it matches the Access table and then append the new data to the existing table. I hope that has helped, best regards Pete
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:Pop up propertyIf you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On. |