Results 1 to 5 of 5

Thread: .DBF Files

  1. #1

    Default .DBF Files

    Hi All,

    Has anyone successfully imported .DBF files into Lavastorm?

    If so, which Acquisition node do I use?

    Thanks in advance.

    Cheers!

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    It looks like you are using the public version of our software. It would be simplest to import the file into Excel, and then use the ExcelInput node from there.

    If you have access to a full version of our software, then you can use the JDBC node to read DBF files.

    You would need to download the appropriate JDBC driver (several are available), and then use a DBurl similiar to this:
    Code:
    jdbc:odbc:Driver={Microsoft dBASE Driver (*.dbf)};DefaultDir=C:\\dblocation
    Start by reading the documentation in the JDBCquery node. A quick google search will turn up several possible drivers.
    http://stackoverflow.com/questions/8...river-for-java

  3. #3

    Default

    Hi stonysmith,

    Thanks for the response. I have a public version at home but am using the LAE 6.1 at work. Appreciate you taking the time out to reply.

    Can you provide more specifics to which jdbc driver you recommend that I download? Also, after some Googling, some are paid drivers (which I don't mind paying if it does the job).

    Thanks again stonysmith.

  4. #4
    Lavastorm Employee
    Join Date
    Apr 2014
    Location
    Boston, MA
    Posts
    279

    Default

    The Windows ODBC Admin also has drivers for DBF. At least on my machine it does!

  5. #5

    Default

    Thanks ryeh. Much appreciated. It was right in front of me all this time!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •