Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appendig from TXT files
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01148257
Message ID:
01148258
Views:
14
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform