Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing Spreadhseets into database

	98.1 % recommend us
	More live stats...

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

Training information:

Importing Spreadhseets into database

Resolved · Medium Priority · Version 2003

Reply Thu 30 Dec 2010, 11:12Delegate Gregory said...

Gregory has attended:
Access Intermediate course
Access Advanced course

Importing Spreadhseets into database

When importing excel spreadsheets into my access tables is there a way to get around having to have the coloumn headings the same in both worksheet and table?

For upcoming training course dates see: Pricing & availability

Reply Tue 4 Jan 2011, 12:15Trainer Anthony said...

RE: Importing Spreadhseets into database

Hi Gregory, thanks for your query. Unfortunately the import wizard uses the column headings in Excel to map onto the same field name in Access and there is no way to get round that using the wizard. However I would recommend a two-step work-around. Set up a separate table in Access linked to the spreadsheet data, then use an append query to remap the fields in that table onto one of your choice. Set up correctly this could work quite seamlessly.

Hope this helps,

Anthony

Mon 10 Jan 2011: Automatically marked as resolved.

Access articles

· So what's new in Access 2007?
· Interested In The Golden Rules For Building Access Databases?
· Practice Microsoft Access Database Decorum To Reap The Rewards
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Find Out All About Microsoft Access Report Sections

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