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
