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

access

ResolvedVersion 2003

Veronica has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Access

Easiest way to import an excel sheet into access

RE: access

Dear Veronica

Thank you for attending Access course. I hope you enjoyed the courses and benefited from them.

The easiest way of importing Excel sheets into Access is to choose File > Get External Data > Import...

In the dialog box please choose Microsft Excel in the file type. Locate the file that needs to be imported. Double click on it.

Follow the Import wizard step by step.

In Excel it is best to start your column headings that need to appear in a Access Table from Row 1.

The last step in the wizard asks you if you want the data in a new table or an existing table.

I hope this answers your query. Please mark the post as resolved.


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access tip:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.