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

access

ResolvedVersion Standard

Malgorzata has attended:
Access Intermediate course
Access Advanced course

Access

What is the best way of importing external data (for example from excel) to the table in the database but not by "copying and pasting"?
Is it possible to create a link or makro that will import the data for you by pressing a butom.

RE: Access

Hi Malgorzata, Thank you for the post, In answer to your question you have the option to link to an external table or in the case of your question to an excel spreadsheet. If linking to an Excel sheet the sheet must be created as a database or as a list, this requires the rules of database to be adhered to; ie. no gap between field headings and data the data should be consistent with the heading, where a row gap or column gap appears the table will be considered to have ended etc.
Using the Menu command File, Get External Data, Change your file type to Excel Spreadsheet, choose link and navigate to your chosen file; follow the wizard options to select your choices. I hope that helps best regards Pete.

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

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