*-- build connection string lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +; "Dbq=c:\temp\test.mdb;" +; "Uid=Admin;" +; "Pwd=;" *-- connect to MS Access lnAccess = SQLSTRINGCONNECT(lcConnectionStr) *-- create the table *-- Note that we need to use Access SQL dialect (char(12) vs. C(12)) SQLEXEC(lnAccess, "CREATE TABLE test (Field1 char(12), Field2 char(12))")>Hi. To make a long story short, I need to create Access 2000 tables and insert them into a .mdb database with VFP 6.0. Template tables reside in this database that I can utilize. For example, when the first record is entered for March, 2001 it will create the table [3-2001-info] from the template table [general_info]. I have disovered how to insert data into an Access database, but I can't find how to create one. If anyone has any ideas, please let me know.