Trying to Copy Structure - Error msg for Table Name

[Guest]

I imported the data for a table via ODBC. The table is a single column with
30,000 records; most of which are duplicates. I went to Access Help and it
said to select the table, copy, then paste-structure. When I try this I get
the following error message

The objecct name " you entered doesn't follow Microsoft Access Object-naming
rules. The name of the table is SubPool. There are no quotation marks or
any punctuation of any type anywhere in the file name. So I'm confused about
what it's telling me. Does it think I named the table "? The name of the db
itself is SubPool Study, US

I tried another table from another db, a table which was create via import
from Excel and I got the same message. Once again there was no punctuation
in the name.

What needs to change in order for me not to be blocked for nomenclature
violations? Thanks

 

[John W. Vinson]

I imported the data for a table via ODBC. The table is a single column with
30,000 records; most of which are duplicates. I went to Access Help and it
said to select the table, copy, then paste-structure. When I try this I get
the following error message

The objecct name " you entered doesn't follow Microsoft Access Object-naming
rules. The name of the table is SubPool. There are no quotation marks or
any punctuation of any type anywhere in the file name. So I'm confused about
what it's telling me. Does it think I named the table "? The name of the db
itself is SubPool Study, US

I tried another table from another db, a table which was create via import
from Excel and I got the same message. Once again there was no punctuation
in the name.

What needs to change in order for me not to be blocked for nomenclature
violations? Thanks

Well... copy and paste isn't an ideal tool in Access.

Did you *import* the data, or link to the ODBC table? What exactly are you
trying to accomplish: create a local table with the same data with no
duplicates? If so, a MakeTable query would be suitable:

INSERT INTO newtablename
SELECT DISTINCT fieldname
FROM odbcetablename;

John W. Vinson [MVP]

 

[aaron.kempf]

with SQL Server you could merely do this and most of the autonumber /
identity type information is transferred

select *
into myEmptyTable

From myTable

Where 1 = 0

mysql has syntax

create table myemptytable like mytable

I would _LOVE_ to see that work in the MS world