Hi Simon,

As already answered on the ticket you submitted,

create virtualtable pdsw!vt_iPadImport connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=S:\xxxxxxx\iPadImport.dbf;Exclusive=No;Base table=iPadImport.dbf;Primarykey=cust_id" as select * from iPadImport

That is gibberish.

You have specified a CONNSTR as oledb then added "basetabe" and "primarykey" to that oledb connection string.

I don't know why you dont just use the GUI which will create it properly.

// CREATE VIRTUALTABLE tablename [IF NOT EXISTS] [ALIAS aliasname] CONNSTR "dsn" [TABLE 'basetable'] [PRIMARYKEY 'column'] [PROPERTIES 'prop=value;...'] [AS select_statement]

create virtualtable pdsw!vt_iPadImport connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=S:\xxxxxxx\iPadImport.dbf;Exclusive=No;" table 'iPadImport' Primarykey 'cust_id' as select * from iPadImport