Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing data
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00387808
Message ID:
00387820
Vues:
24
Hi Ryan,

Your dates should not be a problem for VFP if they are recognised by CTOD().
What do your dates look like e.g.

  03-Jul-2000    <- Not supported.
  03-07-2000     <- Would need to use SET MARK TO "-"
  03/07/2000

How are your records delimited?
Are all of your values in quotes?

Why not just use something like the following?

For comma delimited:
   APPEND FROM -SourceFile.Txt- TYPE DELIM

For Tab delimited:
   APPEND FROM -SourceFile.Txt- TYPE DELIM WITH TAB

For fixed length fields (i.e. no separators)
   APPEND FROM -SourceFile.Txt- TYPE SDF
this list could get very big!

More info would be useful.
Regards,
Houston.
censored.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform