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

importing information

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing information

Importing information

ResolvedVersion 2003

Vinita has attended:
Access Introduction course
Access Intermediate course

Importing information

Is there a way to import information directly from another database i.e SAP?

RE: Importing information

Hi Vinita

It is possible to import data from another database. Either create a new database and from the task pane choose Project using existing data. Access will take you to a Data link dialogue box that lets you choose the data source for your database.

If your Access database already exists try going to the File menu and choosing Get external data. This requires an ODBC connection to be setup that makes your source database accessible to Access.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

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