Create Table Error (SQL inside Macro)

[PedroDC]

Greetings.

I have a macro in access wich is supposed (among other things) to create a new table.

However, I'm having trouble with the Data Type definition, because I get the message:

"Runtime Error 3292: Syntax error in field definition."


The code I'm using is:

SQL = "CREATE TABLE Relatorio(EXTRATO), FlightDate Date(dd/mm/yyyy)"
DoCmd.RunSQL SQL

Please help!
Many thanks in advance

 

[Norie]

I'm not 100% sure what you want to do but this code works for me.

SQL = "CREATE TABLE Relatorio (FlightDate Date)"
DoCmd.RunSQL SQL

It creates a table called Relatorio with a Date field named FlightDate.

Is that what you want?

 

[VicRauch]

I was able to get this SQL string to create table Relatorio:

CREATE TABLE Relatorio(EXTRATO text(5), FlightDate Date;"

This created the table, a field named EXTRATO that is text, and 5 characters, then FlightDate as a date.

I could not find the documentation on how to define the format for a field, such as dd/mm/yyyy as the format the the FlightDate.

But the statement did create the table.
HTH,

 

[PedroDC]

Quite allright, many thanks both!