G Guest Jul 15, 2005 #1 Does anyone know how to do a make table using vb? I am running SQL in one of my functions and need to create a table.
Does anyone know how to do a make table using vb? I am running SQL in one of my functions and need to create a table.
J Joerg Ackermann Jul 16, 2005 #2 James said: Does anyone know how to do a make table using vb? I am running SQL in one of my functions and need to create a table. Click to expand... use (DDL) SQL -> currentdb.execute "CREATE TABLE... or use VBA -> CreateTabledef-Method There are several examples in access-help Acki
James said: Does anyone know how to do a make table using vb? I am running SQL in one of my functions and need to create a table. Click to expand... use (DDL) SQL -> currentdb.execute "CREATE TABLE... or use VBA -> CreateTabledef-Method There are several examples in access-help Acki
G Guest Sep 16, 2005 #3 dim mySQL as string mySQL = "create table Fred (txtText char(50), datDate datetime, intInt int)" docmd.runsql mySQL If you want to make a table from existing data, replace the mySQL text with text stolen from a make table query.
dim mySQL as string mySQL = "create table Fred (txtText char(50), datDate datetime, intInt int)" docmd.runsql mySQL If you want to make a table from existing data, replace the mySQL text with text stolen from a make table query.
