Page 1 of 1
Accessing DBF (Database File) using TI
Posted: Fri Nov 11, 2011 9:00 am
by 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
Re: Accessing DBF (Database File) using TI
Posted: Fri Nov 11, 2011 9:51 am
by Duncan P
Create an ODBC data source for your file and then use a SQL query into it.
Re: Accessing DBF (Database File) using TI
Posted: Fri Nov 11, 2011 1:12 pm
by 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.
Re: Accessing DBF (Database File) using TI
Posted: Mon Nov 14, 2011 1:10 pm
by 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.
Re: Accessing DBF (Database File) using TI
Posted: Tue Dec 06, 2011 2:50 am
by 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