Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>Hi all,
>I have a text file. I want to read it line by line.
>What is the best way to do this?
>Thanks
Hi Reza
I believe the fastest thing is to create a temporary table with field names and data types that match the system you're importing into.
Append from the text file into the temporary table. Fix anything that's not quite right.
Scan the temp table and insert/update data in the the real table(s).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only