Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Importing information

Resolved · Medium Priority · Version 2003

Reply Wed 18 Feb 2009, 16:27Delegate Vinita said...

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 12 Mar 2009, 09:45Trainer Andrew said...

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 articles

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Discover How To Link An Excel Spreadsheet To An Access Database
· Innovation with Microsoft Access
· How To Filter And Sort Data In Access 2010 Tables
· It's so easy to Access the information you need

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips