>I am looking for a really big data file to use in a VFP demo. I wanted something with a few hundred thousand records, like street names or postal codes or something like that I could run queries on both using DBF files and also with the data transfered to SQL Server. If someone has a file they'd like to share, or a routine that builds a big file (a few hundred megs, a few million records!) I would appreciate it.
>
>Or if you can point me to somewhere on the web where i can grab a big text file I can convert into to DBF that would be useful too.
Just build a routine that loops and appends records into a file.
CREATE CURSOR myCursor (cfield C(10), nfield i)
FOR i = 1 TO 1000000
INSERT INTO myCursor Values (SYS(2015), i)
ENDFOR
You could get as creative as you want with random values.
Erik Moore
Clientelligence