linking to .mdb table
Can I create a new Excel spreadsheet linked to an existing Access table.
Creating an access table linked to an existing .xls is not an option in this
case. The .xls would preferably be "read-only" but that isn't TOO critical
an issue. (Will be resolved in Apr '05 when we can buy more ACCESS licenses,
but budgetary restraints in place now)
Only option I've seen is to Drag the required Access tables into .xls then
create new access tables linked to XL tables... there MUST be a better way!!!
Thanx - David
|