A maketable query will give you a table with the same fieldnames with no
need for a link. It copies the data from the old table (linked or
otherwise) and retains the same field names as the original linked table.
You can run the query from inside VBA either by referencing a query in the
querydef collection (ie one you have saved) or by placing the sql statement
into a string variable in the code and then executing it.
Regards
Kevin C
"colmkav" <colmjkav@yahoo.co.ukwrote in message
news:1178279053.591639.202870@u30g2000hsc.googlegr oups.com...
Quote:
On 4 May, 12:14, "Kc-Mass" <connearney_AT_comcast_PERIOD_netwrote:
Quote:
>Run a maketable query against it with the new table in the other DB.
>That gets you all the data. In regard to settings that would very much
>depend on
>what type of table/file you are linked to. Going from Oracle to access
>or
>SQL Server to Access
>you can't take all the settings, from Excel there probably are none.
>Course
>if it is an Access table you just go to the original table and copy and
>paste it into the new DB.
>>
>Regards
>>
>Kevin C
>>
>"colmkav" <colmj...@yahoo.co.ukwrote in message
>>
>news:1178262152.080950.294900@o5g2000hsb.googlegr oups.com...
>>
>>
>>
Quote:
Hi, I need to copy a linked table but without keeping the link. ie
all the data and settings accept for the link to another db.
>>
Quote:
How can I do this?
>>
Quote:
Colm- Hide quoted text -
>>
>- Show quoted text -
>
It is an access table. I tried copying it but end up with a linked
table. Also I want to do it with VBA code. If I just copy it into a
blank table as you suggest, the field names have to all be changed.
>
If I do a maketable will that just give me all the same design as the
linked table ie field names all the same etc?
>
Colm
>
