Delete the table link but keep the table

[Maureen]

In Excel, there is a way where you could remove a link and
still keep the current data that you have. Is there such
a thing in Access where all the Excel Linked Tables could
be converted to a table, meaning, remove the link and keep
the table in Access? I want to be the administrator of
the Access report, however, when I email the Access report
to the other staff, it will search for the link tables.
My solution is to remove the links and keep the table
static, but I'm not sure if that's possible in Access.
Please help!

Thanks in advance!

 

[John Vinson]

Is there such
a thing in Access where all the Excel Linked Tables could
be converted to a table, meaning, remove the link and keep
the table in Access?

Simply Import the data instead of Linking it. Or am I missing
something?

 

[Maureen]

I've already have everything linked from Excel... and I
have over 10 sheets linked already and have created
relationships,queries,forms and reports. I don't want to
lose any of that and so I'm looking for a simple way to
convert it to a table without having to lose the source
and re-create the relationships, queries, forms and
reports....

 

[John Vinson]

I'm looking for a simple way to
convert it to a table without having to lose the source
and re-create the relationships, queries, forms and
reports....

<puzzlement> You cannot have enforced relationships to linked tables
(particularly linked spreadsheets) in any case. What you could do is
rename all your linked tables (perhaps to xlsTablename) and then run
MakeTable queries to migrate the data from them into native Access
tables, or (probably better, knowing Excel linkage's quirks) create
empty Access tables with proper field types, etc.; relate them, with
relational integrity enforced; and run Append queries to populate
them. Your Queries and Forms which reference MyTableName (a linked
spreadsheet) will now referenc MyTableName (the Access table) and
should still work.

Of course, the Access tables will no longer automatically reflect
changes made to the spreadsheets in Excel.