Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+course - Linked tables

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft+access+course - Linked tables

Resolved · Low Priority · Version Standard

Reply Fri 31 Aug 2007, 12:58Delegate Martin said...

Martin has attended:
Access Advanced course

Linked tables

Can Access 2003 link to excel 2.1

For upcoming training course dates see: Pricing & availability

Reply Tue 4 Sep 2007, 10:07Trainer David said...

RE: Linked tables

excel 2.1? are you sure this is the right version?

Reply Tue 4 Sep 2007, 10:14Delegate Martin said...

RE: Linked tables

The data is derived from a web-site running an old version of Brio. The default output is excel 2.1, which I currently have to open and save into a later version for the database to read it.

Reply Tue 4 Sep 2007, 16:11Trainer David said...

RE: Linked tables

sorry, what is brio?

Reply Tue 4 Sep 2007, 16:43Delegate Martin said...

RE: Linked tables

Brio is a reporting package similar to Crystal.

Reply Tue 4 Sep 2007, 19:56Trainer David said...

RE: Linked tables

ok, have you tried opening excel 2.1 in excel and saving it as a later version?

Reply Wed 5 Sep 2007, 08:38Delegate Martin said...

RE: Linked tables

Pasted from my original question:

"The default output is excel 2.1, which I currently have to open and save into a later version for the database to read it."

I do not wish to open and save a file, I would like to link to it as exported from the web site.

Reply Thu 6 Sep 2007, 11:29Trainer David said...

RE: Linked tables

Martin

I dont think it can, but we will keep checking.

regards

info

Access articles

· How Does The Startup Work When Access 2010 Launches The Northwind Database
· User-Proofing Your Access Database: Part 1
· Find Microsoft Access Templates For Any Task
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Access 2007 Is All About Systems

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips