By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

copy linked tables

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.