Accessing DBF (Database File) using TI

[mariatjahjadi]

Hi,

Is there anyone know how to access DBF and excel using TI?

I need to access DBF and excel as a data source.

Thanks.

Maria

[Duncan P]

Create an ODBC data source for your file and then use a SQL query into it.

[David Usherwood]

Giving the antiquity of the DBF format, if you are running 64 bit TM1 (or Cognos Express) you may have some challenges sourcing 64 bit drivers.

[Harvey]

I recall reading that there are OLE DB DBF drivers included as part of Visual Foxpro. Not sure if they will work, but it's worth a try.

You can download the drivers from Microsoft's site.

Please report back and let us know if you find the answer.

[mariatjahjadi]

I can access DBF using TI.

1. Open administrative tools
2. Double click odbc
3. Choose dBase Files and click configure
4. Click select directory, point to your dbf files directory
5. Click ok.

In TI, choose odbc and dBase driver, then you can select your dbf file name.

Hope it will be useful.

Thanks.

Cheers,
Mtjahjadi