Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
They always move the goal-posts, don't they
Message
From
05/07/2005 10:56:05
 
 
To
05/07/2005 10:48:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01028919
Message ID:
01029005
Views:
18
>Here is the idea behind it:
>-Analyze text file to determine its type
>-Create a cursor that'd hold all the information as possible from text file (ie: if it's determined to be a tab delimited file, tab count gives generic intermediate cursor's field count. Start with all of them 254 in width, append then shrink widhts)
>-Map user columns to target's columns
>-Rename columns that'd be imported
>-Append from (or scan...insert...endscan)
>Roughly that's it. Our users were importing various formats from mainframes and this was the one I came up with.
>Cetin

Cetin

I totally trust you on importing matters! You proved it over my CIF import data. So if you've said this is the way to go about it I know it must be the optimum. And it sounds fairly simple. It looks like this is way to go.

Thanks

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform