Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

alter table alter column

7 views
Skip to first unread message

Valérie Labonne

unread,
Jul 24, 2002, 10:44:03 AM7/24/02
to
Is there a way in access to alter the datatype of a column with an SQL
query?

eg:
alter table alter column set ...

It doesn't seem to work. Anyone has an idea?

Valérie Labonne

unread,
Jul 25, 2002, 3:21:24 AM7/25/02
to
ok thx


Chuck Grimsby wrote:

> You can't alter a column's datatype in access via a query.
>
> You have to alter the table to add in a new column,
> use a update query to move the data over to the new column,
> then another alter query to delete the old column.

0 new messages