CREATE TABLE SQL Statement

[benasumwa]

Hi all,

How do I create a an access table programatically
though a connection with the DEFAULT clause included?

This statement fails:

CREATE TABLE MyTable (MyField1 Numeric NOT NULL DEFAULT 0)

But works with the DEFAULT removed.

I have a round 100 tables to CREATE, but in access
database. My front-end is Visual Foxpro 6.0.
The table definitions are available and the easiest
thing to do is to create them through a connection by sending SQL statements. This method works until
I include DEFAULT stuff.

Any idea?

---------------------------
Benson O. A.
Infinity Link Limited

 

[xlbo]

Whilst Access does fit into MSOffice, you may be better off posting this in one of the (3) Access specific forums....