Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setting import start point
- Thread starter woodyinoz
- Start date
Woody,
Without mangling the source file, I'd probably simply import into a temporary table and then use a query or something similar to move the actual data into the real table.
Alternatively, you could roll your own import routine using textStream and then place the data into your table using a TCursor. It would be some work, but the results would be faster than the original idea.
It depends on how frequently you want to do this. If this is a one-shot, I'd just do it the easy way.
Hope this helps...
-- Lance
Without mangling the source file, I'd probably simply import into a temporary table and then use a query or something similar to move the actual data into the real table.
Alternatively, you could roll your own import routine using textStream and then place the data into your table using a TCursor. It would be some work, but the results would be faster than the original idea.
It depends on how frequently you want to do this. If this is a one-shot, I'd just do it the easy way.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Question