Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing from Excel
Message
De
19/07/2002 05:34:30
 
 
À
19/07/2002 03:25:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00680330
Message ID:
00680339
Vues:
26
>Hi Guys,
>I am trying to import something from excel into an exsisting DBF. Whats the simplest way to do it? I have made sure all unique keys are correct. I also have a logic field in that dbf, is there anything I have to do specially to match the datatype? I have put .T. in the excel file as true, would that work? I have never done this, hope someone can help me out~ ^_^
>thanx
>^_~
>Tom

Tom,

Logical fields in excel are TRUE or FALSE

I've create a spreadsheet with a1 TRUE b1 FALSE, and a2 FALSE b2 TRUE

IMPORT FROM c:\tmp\test.xls TYPE XL8 SHEET "Sheet1" makes the two columns (a and b) logical

Maybe this can help you get started
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform