Excel to Access

The UK's most regular instructor-led training courses.
Training information: access class microsoft training · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

1 post

ReplyMon 22 Jun 2009, 14:14Delegate Stuart said...

Stuart has attended:
Access Introduction course
Excel Advanced course

Excel to Access

How do I copy multiple data over more than one tab in an excel spreadsheet into and Access table?

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

870 posts

ReplyTue 23 Jun 2009, 12:08Trainer Rajeev said...

RE: Excel to Access

Dear Stuart

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

My suggestion would be to first import the Excel data from one sheet.

The step of doing this is as follows:

1. Open the database where you would like the Excel data to be imported.

2. Choose External Data tab from the ribbon and then click on the Excel icon in the Import Group

3. Click on the browse button to choose the Excel file where the data will come from and then choose the file. Press Open button

4. Select the first option to have the new data imported in a new table. Press Ok button

5. Choose the Worksheet where the data will come from.

Note: Please try to ensure that the worksheet has no Main heading and subheadings. Try to have the first row in eth worksheet to have the Column headings.

6. Press Next button. Ensure that you have got the tick on First Row contains Headings especially if your first row in the worksheet has column headings. Press Next Button

7. In this step specify if you want any column not to be imported by using the check box Do not Import field (Skip). Press Next.

8. Either let Access add a Primary key or choose your the Primary key of your own choice or simply select no Primary key. Press Next

9. Provide a relevant name for the new Table. Press Finish/

Once you have gone through the steps and imported the data in the new table. Simply Go through Steps 1-3 mentioned above. But this time please ensure that you choose the option that mentions append a copy of the records to the table: option. Choose the table that you want the new records to be imported into.

Choose the sheet that contains the data.

NOTE: It is very important to verify that both sheets have the same column headings. Otherwise in your last step on the import it will give you an error message and the importing will not be successful.

You can repeat that until you get all the data from all the relevant sheets.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 29 Jun 2009: Automatically marked as resolved.

· Why a Microsoft Access Course Could Change the Way You Do Business
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· MS Access and Database Normalisation
· Data validation in MS Access
· Some Simple Database Questions Answered

Please browse our web site to find out more about
access class microsoft training and other Microsoft training courses.