excel ssheet into 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 » Excel s/sheet into Access

Excel s/sheet into Access

resolvedResolved · Low Priority · Version 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:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.09 secs.