469,076 Members | 1,501 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

copy linked tables

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.

How can I do this?

Colm

May 4 '07 #1
4 5963
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" <co******@yahoo.co.ukwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
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.

How can I do this?

Colm

May 4 '07 #2
On 4 May, 12:14, "Kc-Mass" <connearney_AT_comcast_PERIOD_netwrote:
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:11**********************@o5g2000hsb.googlegro ups.com...
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.
How can I do this?
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

May 4 '07 #3
On May 4, 7:44 am, colmkav <colmj...@yahoo.co.ukwrote:
On 4 May, 12:14, "Kc-Mass" <connearney_AT_comcast_PERIOD_netwrote:


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:11**********************@o5g2000hsb.googlegro ups.com...
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.
How can I do this?
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- Hide quoted text -

- Show quoted text -
Do you have access to the database that contains the linked table?

May 4 '07 #4
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" <co******@yahoo.co.ukwrote in message
news:11**********************@u30g2000hsc.googlegr oups.com...
On 4 May, 12:14, "Kc-Mass" <connearney_AT_comcast_PERIOD_netwrote:
>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:11**********************@o5g2000hsb.googlegr oups.com...
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.
How can I do this?
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

May 8 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Chinmoy Mukherjee | last post: by
4 posts views Thread by Neil Ginsberg | last post: by
3 posts views Thread by david | last post: by
19 posts views Thread by davidgordon | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.