>Could someone please let me know what is limitation in VFP on table size?, record number?

Maximum size of a table file 2 gigabytes
Maximum # of records per table file 1 billion
You may check "System Capacities" in Help to see other limitations.