Need help using excel to amend ibm reflections

15 pts.
Tags:
AS/400
IBM Reflections
Microsoft Excel
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them. What I want to do, which I would do if it were two excel files, is update the database file by using a vlookup to match the customer numbers then fill in the needed fields. I tried to run a macro to see what the code looks like but I don't see how to look up the entry by the cust name and amend the other parts. FYI I can only access the screen from which to manipulate the data using the terminal. Please help! I know I am more or less asking for the whole code but repititive tasks and not being able to figure out the easy way make the OP go crazy.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Riotburn
    Also I dont have access to file transfer or a way to get to the file I manipulating. I am guessing that I may be seeing the file name at the top of the screen so maybe i can use that to run the loop but I dont know how that will be formatted.
    15 pointsBadges:
    report
  • rbriggs

    Hello,

    I want to help you and give you a free licence to a nice software utility.

    The utility 'Excel to database' that will do this task easily for you and I would like to confirm that it works with IBM Reflections.

    Essentially the application allows you to copy and paste data into an excel insert/update template that you can very easily define.

    We have many users with SQL Server, Access, FoxPro, MySQL but I need to get things working for IBM Reflections - so if you will allow me to help you I will give you a free licence :)

    You can find the utility here :

    http://leansoftware.net

    Best regards

    richard.briggs@leansoftware.net

     

    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following