Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Advice on speeding up sending data to Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00036697
Message ID:
00036735
Vues:
34
> In my application I use the following code to create an Excel spreadsheet > and populate it with the contents of an array that was created with a SQL > Select into statement. Sometimes the array is large, over a 1000 records, > and this process can be lengthy (5-10 minutes). Any advice on how to speed > this up? Is it feasible, instead of using an array, to use a cursor or table? I just tried COPY TO .. TYPE XLS with 1400+ records from a cursor, and it took a second or so. I'm using a P120 with 32Mb RAM & Windows '95. /Paul
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform