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 » Access

	98.1 % recommend us
	More live stats...

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

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Tue 6 May 2008, 16:52Delegate Arabella said...

Arabella has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access

How to transfer information on a number of excel spreadsheets into an exsiting access database when the database is listed in employee order

For upcoming training course dates see: Pricing & availability

Reply Wed 7 May 2008, 09:53Trainer Pete said...

RE: Access

Hi Arabella,
Thank you for your post, in answer to your question, I would follow the Get External Data operation; This allows you to Import or to Link your Excel spreadsheets into your database, so long as your Excel spreadsheet matches the Access table (All fields including ID field) you should be able to import to an existing table, if not you might have to import the spreadsheet to a new separate table, manipulate your data until it matches the Access table and then append the new data to the existing table. I hope that has helped, best regards Pete

Access articles

· Microsoft Access Flaws and Ways to Overcome Them
· It Is Important To Take Care Over Primary Key Assignment
· Getting To The Nitty-gritty Via Microsoft Access
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access, an Efficient Database Tool

Please browse our web site to find out more about
ms access courses 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