Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Appendig from TXT files
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01148257
Message ID:
01148258
Vues:
13
>I use to receive TXT files which the first line belongs from another table
>I have three questions about this issue
>
>1-Is it possible to skip this first line when appending or I really must treat it after importation already in DFB ?


You can use FOR clause to filter out unwanted records

>2- It's not delimited and I am using SDF type, is it correct ?

It's correct if file has fixed layout

>3- It there any technique to import directly to date, numeric fields or do I have to import all to character fields and then transfer them to another table

If date is in the format YYYYMMDD than you can import it directly into a date field. You shouldn't have problem importing numeric data into the numeric fields.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform