Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run queries against table .dbf
Message
 
To
27/09/2016 14:09:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01641414
Message ID:
01641420
Views:
34
>Thanks a lot Borislav, this is helpful.
>
>this table has close to 205k rows and when i execute teh command you provided for XL5, i see it started but hanging at 16384 rows with excel. seems like that is teh limit i see on google.
>
>is there a way i can export to .csv file, may be that will hold much larger amount of rows than excel file.
>
>or a txt file is also fine with a delimier.
>
>USE DocIndex
>COPY TO DocIndex XL5
>
>And the file gets created to which path?
>
>Can i create file in same place as docindex.dbf table folder path or can i specify the file to get created in "c:\myexports"
>
>Kind Regards, thanks a lot for the helpful ino

You can set full path to COPY TO command;
USE DocIndex
COPY TO c:\myExports\DocIndex XL5
BUT you can not avoid 16k rows. Also if you have MEMO fields they will be not exported.
You can check this:
http://praisachion.blogspot.bg/2016/03/bug-fixed-generated-document-contains.html
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform