Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP dbf file created from Excel spreadsheet shows old co
Message
De
07/01/2000 06:51:05
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
06/01/2000 12:52:37
Gordon Mcleod
Shieldaig Corporation
Calgary, Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00314000
Message ID:
00314399
Vues:
33
>I created a VFP dbf file from an Excel spreadsheet and modified cdx file to correct layout changes and indexes. In design time environment BROWSE shows the new database with 281 records. During runtime browsing the database stops at the old record count of 227 but shows the last record as being 227/281.
>
>What is happening here and how can I correct this problem?


Gordon,
First I'll try the silly one. Could it be the order ? I mean record 227 might be the last in current order.

Next, I have encountered problems with importing data from excel. "Import" and "append from" work different. MS have KB entry about it. You may hit it if excel sheet was pasted, pasted special to fill cells. Also if it's imported into a database with a name clause it doesn't always get the desired sheet but first sheet.

Last, a totally new table with fresh cdx (better created after appending). In excel you could save as a CSV and "append from" in VFP.
Hope helps.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform