Avatar of francodhs
francodhs
Flag for United States of America asked on

WebSphere Host On-Demand data to a microsoft access table?

Can anyone provide me with a solution on how to transfer WebSphere Host On-Demand data to a microsoft access table?  I have been looking for a tutorial to extract data from this Java-run program into an Access table.  I heard from sources that this was being done via Foxpro, but I wish to use Access as the host,
Microsoft AccessDatabases

Avatar of undefined
Last Comment
francodhs

8/22/2022 - Mon
Gary Patterson, CISSP

Not sure I understand what you want to do.  Can you explain your requirements in a little more detail?  

Do you need to move your HOD configuration to another server?

If so, then you just need to follow the appropriate migration process for your HOD version and platform.  If you'll post your HOD platform and version, I can point you to the right manual that documents the migration process.

- Gary Patterson
francodhs

ASKER
Gary,

First of all, kudos on your accomplishments.  The IBM system that we currently have in place is used in a secure-server environment to schedule employees.  I'm working on automating our schedule in Access to include more features such as locations.  The IBM program is straight shift times with no locations.  I'm not sure whether I need to establish some type of ODBC connection to Access, but the scheduling program seems to have a transfer option that I'm not familiar with.  I'm sending you a snapshot of the toolbar with the transfer options.  What I would like to do is select a pay period with employee schedules and transfer the list to an Access table for further processing.  I hope this makes sense.

screen.jpg
ASKER CERTIFIED SOLUTION
Gary Patterson, CISSP

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
francodhs

ASKER
I'm familiar with ODBC, as I've used it in the past to connect Infopath forms to Access. I may have to get with my local IT to get more info. XP is the OS.  Do you have a tutorial using ODBC in this context?  This operation seems like it requires quite a bit of info, but hopefully you can provide me with with a sense of direction.  It program resides in the same server, and I'm not too sure about the file name for the data i wish to extract.  Perhaps we can use a generic name for this scenario.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
francodhs

ASKER
Solution not found for my scneario.  Appreciate the attempt.