External data in Access

  • Thread starter Thread starter Jim Caton
  • Start date Start date
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
 
Hi

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


Arvi Laanemets
 
Arvi,

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

Jim
 
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
 
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
 
Back
Top