HomeForum
Welcome, Guest

Add New and Update Old Records
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Add New and Update Old Records

Add New and Update Old Records 1 year ago #2711

  • Greg
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
Hello

For some reason my update is not working.
When I try and update a file with 767 records it updates all the fields with the last record in the file.
Source is text and writer is access table.
Any ideas?

Thanks,
Greg

Re: Add New and Update Old Records 1 year ago #2712

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Greg

Have you selected update key?

Page 91 of documentation

Also watch this tutorial

www.dbsoftlab.com/online-tutorials/advan...d-etl-processor.html

Peter

Re: Add New and Update Old Records 1 year ago #2713

  • Greg
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
Thanks for looking at this. This is a great tool and I'm trying to learn how to use it better so I can spread the word.

I want to update three fields, one being a key but not designated a key within the Access table. I don't see a tutorial on this page just two screen shots?

Thanks,
Greg

Re: Add New and Update Old Records 1 year ago #2714

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Greg

You are one click away form the solution

Have a look at attached screen-shot,
Peter
Attachments:
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

Well this great product and I’ve ever seen …. Yet.

Inexpensive
User friendly
Trusted and Reliable
Best features
Great support
Very fast and best performance
Recommend for all groups (small, medium, large / enterprise)

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top