Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to run queries against table .dbf
Message
 
À
27/09/2016 14:09:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01641414
Message ID:
01641420
Vues:
35
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform