microsoft+access+course - linked tables

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

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

microsoft+access+course - Linked tables

resolvedResolved · Low Priority · Version Standard

Martin has attended:
Access Advanced course

Linked tables

Can Access 2003 link to excel 2.1

RE: Linked tables

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

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.

RE: Linked tables

sorry, what is brio?

RE: Linked tables

Brio is a reporting package similar to Crystal.

RE: Linked tables

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

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.

RE: Linked tables

Martin

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

regards

info@stl-training.co.uk


 

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips


Server loaded in 0.11 secs.