Skip to main content

developerworkslabel >  Information Management  >  forumlabel  >  IBM DB2 Express Forum  >  developerWorks

Access import to DB2    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     
 
 
loginbox.header
 loginbox.welcomelabel loginbox.guestlabel
loginbox.signin
Reply to this Thread Reply to this Thread Post New Thread Post New Thread useraction.watchpage useraction.watchpage useraction.settings useraction.settings help.pagetitle help.pagetitle
Permlink Replies: 2 - Pages: 1 - Last Post: Nov 6, 2009 10:25 AM Last Post By: fgkalbente
lrmikwen

Posts: 4
Registered: Nov 04, 2009 11:47:37 AM
Access import to DB2
Posted: Nov 04, 2009 11:57:45 AM
Click to report abuse...   Click to reply to this thread Reply
Hello,

I'm new here so hello to all of you.

I am running DB2 and I am having a problem importing data to the database. I have some data on Access and my target is DB2. Any idea on how to migrate the data from Access?

Thanks to all of you.
IBM employee or contractor DavidSky

Posts: 28
Registered: Apr 06, 2006 05:53:34 PM
Re: Access import to DB2
Posted: Nov 05, 2009 04:35:13 PM   in response to: lrmikwen in response to: lrmikwenthread.responsepost
Click to report abuse...   Click to reply to this thread Reply
Hi, and welcome!

Can you provide more details about the problem? Are you exporting your data from Access then trying to import it into DB2? Are you connecting the two with ODBC? Is this a one-time requirement, or are you going to need to repeat this import on a regular basis?

While not specifically what you're trying to do, the article by Paul Zikopoulos DB2 9 and Microsoft Access 2007 is worth a look.

David Sky - DB2 Information Development
IBM Toronto Software Lab
fgkalbente

Posts: 6
Registered: Oct 16, 2009 08:01:28 AM
Re: Access import to DB2
Posted: Nov 06, 2009 10:25:54 AM   in response to: DavidSky in response to: DavidSkythread.responsepost
Click to report abuse...   Click to reply to this thread Reply
Check the article provided by DavidSky it might help you resolve your problems. Alternatively, you could be using a software solution such as Datastage which could import the data. As another option, look at Talend which is free to download. Give us you feedback and other problems if you have any.
Pages: 1
Go Back Back to Thread List
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 
MoreLess 

Update your My developerWorks profile and start connecting with others.

Point your RSS reader here for a feed of the latest messages in all forums