One of the solutions is something like this:

store SQLSTRINGCONNECT(;
	'DBQ=c:\db1.mdb;'+;
	'DefaultDir=c:\;'+;
	'Driver={Microsoft Access Driver (*.mdb)}');
	TO gnConnHandle
?sqlexec(gnConnHandle,"Insert into tablename (field1,field2) values ('2','HELLO')")
=sqldisc(0)

>Is it possible to move records, with selected fields to a table in access from VFP 6.0? If yes, how do I go about doing it? Thanks for your help and consideration. ~Brad Woods