Alter table syntax error

[scottb]

Hi everyone.
I am trying to run an alter table sql on an imported table to insert a field.
Access doesn't like the table name in the following and throws a syntax error:

Alter table Page 4- People
Add Column FacilityID Numeric

Is there a way to get this to work using the existing table name (bad as it is) ? There is an existing import and overwrite process that looks for that table name which would be a mess to rework.

Thank you for any help.
-Scott

[HansV]

If a table or field name contains spaces, punctuation etc., you must enclose it in square brackets.
And Numeric is not a valid data type in Access - use Long for whole numbers, or Double for numbers with decimals.
So, for example:

ALTER TABLE [Page 4- People] ADD COLUMN FacilityID LONG

[scottb]

Thank you Hans.

[grovelli]

Thanks for the heads-up and a Happy Easter

[HansV]

Buona Pasqua!