Solved

Import DB2 v5 into Access

Posted on 2004-04-13
6
800 Views
Last Modified: 2010-05-18
Hi,

I have a DB2 database file named data1.001 that is from a customer of ours. I need this imported into access but I only see dBaseIII, IV and 5 in the list.

I have looked around and think I need a Microsoft ODBC Driver for DB2 (Msdb2ole.dll?)

Where can I get this? Preferable for free and without and licencing problems.
0
Comment
Question by:JeremyCrouch
  • 3
6 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10817124
when u do find it and run into problems this might help

http://support.microsoft.com/default.aspx?scid=kb;EN-US;216428

0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 10817153
according to this
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/t0006416.htm

you need to install DB2 if not there

sorry couldnt be more help

0
 
LVL 4

Author Comment

by:JeremyCrouch
ID: 10822914
Yeah, that will probobly be helpfulll if I ever find a actual driver/app.

Another thing... Is DB2 the same as dBaseII? I had assumed it was an earlier version of dBaseIII, IV and 5, but it looks to be a completely seperate databse.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 10823034
DB2 is IBM's database, Dbase is a very old database,if I remember rightly a filebased one, DB2 is a relational database

Dbase and DB2 are not related

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question