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

excel ssheet into access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Excel s/sheet into Access

Excel s/sheet into Access

ResolvedVersion 2003

Erikvan has attended:
Access Introduction course

Excel s/sheet into Access

How do I move a large Mcsft Excel s/sheet into a Mcsft Access Table?

RE: Excel s/sheet into Access

Erikvan,

Thank you for asking the question. My name is Greg and I have just joined Best.

To answer your question, first of all you need to go to MS Access first, then go to File from the Menu Bar of Access, then Get External Data, then Import.

After that, you find the file (make sure that File of Type) option is set to Microsoft Excel, choose it, then go through the Wizard.

I hope this helps. Please contact me if there are any problems.

Thank you.

Greg

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

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.11 secs.