access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Pop up property

If 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.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips


Server loaded in 0.09 secs.