@Jordan_spencer2001
You can also use CHAR instead of VARCHAR but both work.
If you want to specify number types e.g. INTEGER, BIT etc, list them as such in your data definition query
For example:
Code:
CurrentDb.Execute "CREATE TABLE ImportedCourses " & _
"(CourseID CHAR(10), CourseDetails MEMO, Weighting INTEGER," & _
" ShowOnReport BIT, AssTarget1 CHAR(50), AssTarget2 CHAR(50), AssTarget3 CHAR(50)," & _
" AssTarget4 CHAR(50), AssTarget5 CHAR(50), Year CHAR(5), SubjectID CHAR(5));"
CurrentDb.Execute "CREATE INDEX CourseID ON ImportedCourses(CourseID) WITH PRIMARY;"
@June7
As you probably already know, using a data definition query or DAO to create tables gives more control over the field sizes and also allows you to create indexes / PK fields