Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


PLS! - Need example to UPDATE Table in DB from external txt file

PLS! - Need example to UPDATE Table in DB from external txt file

PLS! - Need example to UPDATE Table in DB from external txt file

I need to UPDATE tables in a Pervasive v10 DB with data that has been exported to an external file (.csv, .xls, etc.).  At the moment I'd like to leave data in the target table intact, updating the records/fields, or adding new records if they do not exist.

I understand that it may be simpler to import the data, deleting all existing data, and if that is the best course of action, then that is the path I will take, but the existing data has been partially updated, and the users do not want to start the update/verification process again. There is the possiblity that the current data in the target can be exported, and combined with the source data outside of DB and then massaged for reimport to the target.  

I am relatively new to hands-on SQL syntax, but have a good understanding of the general nuts and bolts.  Essentially, I am asking for someone to tell me how to do it, and provide a sample command structure, because due to pressure and time constraints I don't have time to figure it out and test it for myself, and I have been unable to locate a suitable/adaptable sample on the web. BTW - I am not opposed to running a single command mutliple times changing source/target parameters as long as it gets the job done accurately and faster than manual.

Thank you in advance for any help or experienced perspective on this task,


RE: PLS! - Need example to UPDATE Table in DB from external txt file

Unfortunately, none of the tools included in PSQL support Updating records.  
You might take a look at the Pervasive Data Integration tools.  They might be able to do what you are looking for. The other option is to write (or have written) a specific tool for your needs that reads the CSV, creates an Update statement from the CSV data and executes the statement.  

Certified Pervasive Developer
Certified Pervasive Technician

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close