Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: dBase IV Creation Insertion DBF
BoxOpen("Test Script","Creating/Inserting dBase IV") cPath = "E:\WBDEMO\ If FileExist("%cpath%DBF.DBF") FileDelete("%cpath%DBF.DBF") Endif cConn = "Provider=MicroSoft.Jet.OLEDB.4.0; Data Source=%cPath%;Extended Properties=dBASE IV" DB = ObjectOpen("ADODB.Connection") DB.Open(cConn) step=1 cSQL = "CREATE TABLE DB4 ( COLUMN_1 TEXT(50) );" DB.Execute(cSQL) ;this works ;cSQL = "INSERT INTO DB4 ( COLUMN_1 ) VALUES ('Joes Bar and Grill');" ;or this to include apostrophe in field var="Joe''s Bar and Grill" cSQL = "INSERT INTO DB4 ( COLUMN_1 ) VALUES ('%var%');" DB.Execute(cSQL) DB.close() ObjectClose(DB) BoxShut() exit
Article ID: W14904
File Created: 2020:09:21:13:36:30
Last Updated: 2020:09:21:13:36:30