If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert linked table design to local table
Hi!
I need to make a local table with the same structure as a linked table. All of the methods I have tried (export, import, cut/paste, copy, etc.) all create the new table as another linked table. I am sure there is a simple way to do what I need but so far it has eluded me. Any suggestions or help is greatly appreciated! BTW this Access 2002. Thanks! Dave Venus |
#3
|
|||
|
|||
Convert linked table design to local table
On Wed, 16 Jun 2004 08:23:58 -0700, "Dave Venus"
wrote: Hi! I need to make a local table with the same structure as a linked table. All of the methods I have tried (export, import, cut/paste, copy, etc.) all create the new table as another linked table. I am sure there is a simple way to do what I need but so far it has eluded me. Use File... Get External Data... Import to import the table *directly from the backend database*; check or uncheck the "design only" checkbox as appropriate. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#4
|
|||
|
|||
Convert linked table design to local table
Open the linked table in Design View, dismissing the warning.
Select and copy everything using Ctrl-A, Ctrl-C Close the table Create a new table in Design View Select the first blank record Paste using Ctrl=V Save the table Dave Venus wrote: Hi! I need to make a local table with the same structure as a linked table. All of the methods I have tried (export, import, cut/paste, copy, etc.) all create the new table as another linked table. I am sure there is a simple way to do what I need but so far it has eluded me. Any suggestions or help is greatly appreciated! BTW this Access 2002. Thanks! Dave Venus |
#5
|
|||
|
|||
Convert linked table design to local table
Why not write a MakeTable query based on the table? Much simpler...
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Robin Proctor" wrote in message . net... Open the linked table in Design View, dismissing the warning. Select and copy everything using Ctrl-A, Ctrl-C Close the table Create a new table in Design View Select the first blank record Paste using Ctrl=V Save the table Dave Venus wrote: Hi! I need to make a local table with the same structure as a linked table. All of the methods I have tried (export, import, cut/paste, copy, etc.) all create the new table as another linked table. I am sure there is a simple way to do what I need but so far it has eluded me. Any suggestions or help is greatly appreciated! BTW this Access 2002. Thanks! Dave Venus |
#6
|
|||
|
|||
Convert linked table design to local table
Certainly more elegant, and easier to automate, but you don't get
certain field properties copied, such as Default Value and Format. Douglas J. Steele wrote: Why not write a MakeTable query based on the table? Much simpler... |
Thread Tools | |
Display Modes | |
|
|