External data in Access

J

Jim Caton

For a uni assignment, I used MS Query in Excel to add
external data from an Access database table. It worked
fine, however, I had to provide the files on a floppy and
when I tried it at uni I realised that it was the Access
database on the hard disk that was linked and not the one
on the floppy!

It was no big deal to do again, however, a few students
may hand in floopies that worked at home thinking all is
OK.

Is there a way of having the link work if both files are
in the same location rather than stipulate the location of
the Access file?

Thanks
 
A

Arvi Laanemets

Hi

Select a cell in returned datarange
Select Data.GetExternalData.DataRangeProperties from menu, and uncheck 'Save
query definition'


Arvi Laanemets
 
J

Jim Caton

Arvi,

Your suggestion just appears to remove the query from the
sheet but I need to keep it and refresh data.

Jim
 
A

Arvi Laanemets

Hi

OK, I reread your first posting, and it seems I didn't understand you at
first try. So yo want to deliver Access data on floppy, are you? Remove
query from Excel table in Uni, insert floppy with mdb and recreate ODBC
query, pointing to mdb on floppy as data source.

Another option is to tamper with query properties - probably Connection
property will do, but I'm not sure. But I think for your case it'll be an
overkill.


Arvi Laanemets
 
J

Jim Caton

Thanks Arvi,

That's what I did. It'll be interesting to see how many
students didn't test their floppies on a pc at uni.

Jim
 
Top