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

microsoft+access+course - linked tables

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

microsoft+access+course - Linked tables

ResolvedVersion 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:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.