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

export

ResolvedVersion Standard

Faith has attended:
Access Introduction course

Export

How do you export from excel to access table

RE: export

Hi Faith, Thank you for the post, In answer to your question to import a table from Excel; Choose the menu command File>Get External Data>Import, From the dialog box, change the Files of Type to Excel and navigate to find the workbook of your choice, follow the steps in the wizard to choose the sheet to import. Ensure that the sheet follows the rules of database creation ie field name column headers, no gaps between header and data etc. I hope that helps, best regards Pete.

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.