Copy structure table

[BB]

is it possible to copy or duplicate the structure of a table, with no data
inside?


Thanks
BB

 

[Guest]

Right click on the table name and click copy. Right click in the database
window and click paste. You will then get a box to enter the table name with
options to just copy structure or structure and data.

 

[BB]

I should do it in a VBA function

BB

Right click on the table name and click copy. Right click in the database
window and click paste. You will then get a box to enter the table name with
options to just copy structure or structure and data.

 

[Guest]

DoCmd.CopyObject, "Original Table", acTable, "New Table"
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM [New Table]"
DoCmd.SetWarnings True

 

[BB]

Sorry, maybe I didn't explained properly the matter:

DoCmd.CopyObject copies structure and data, I need only the structure.
Thanks
BB

DoCmd.CopyObject, "Original Table", acTable, "New Table"
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM [New Table]"
DoCmd.SetWarnings True

I should do it in a VBA function

BB

name
with no
data

 

[Guest]

Yes I know, that is why I gave you the other lines of code including the
'DELETE * FROM the New table' after you have copied it.

Sorry, maybe I didn't explained properly the matter:

DoCmd.CopyObject copies structure and data, I need only the structure.
Thanks
BB

DoCmd.CopyObject, "Original Table", acTable, "New Table"
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM [New Table]"
DoCmd.SetWarnings True

I should do it in a VBA function

BB

"Dennis" <[email protected]> ha scritto nel messaggio
Right click on the table name and click copy. Right click in the database
window and click paste. You will then get a box to enter the table name
with
options to just copy structure or structure and data.

:

is it possible to copy or duplicate the structure of a table, with no
data
inside?


Thanks
BB

 

[Dirk Goldgar]

I should do it in a VBA function

DoCmd.TransferDatabase _
acImport, _
"Microsoft Access" , _
CurrentDb.Name, _
acTable, _
"OriginalTable", _
"CopiedTable", _
True

 

[Khalil Handal]

Hi,
Open your Access (a new Database)
clikc on file
mouse to : Get external data
then: import (click)
select the file that contains your table that you want to import the table
structure only.
Select your table

go to options and choose: Defenition only.