Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 843
  • Last Modified:

Import DB2 v5 into Access

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
JeremyCrouch
Asked:
JeremyCrouch
  • 3
1 Solution
 
rockiroadsCommented:
when u do find it and run into problems this might help

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

0
 
rockiroadsCommented:
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
 
JeremyCrouchAuthor Commented:
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
 
rockiroadsCommented:
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now