Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: PowerPivot and DBF files linking?

    I recently had PowerPivot installed but have not used it much. Additionally, I'm losing Access 2003 and my ability to query DBF files exported from our system. Is there any way to link these databases into PowerPivot to query them? I tried opening the files in Excel to save them as a different format that I could then query in newer versions of Access (DBF not supported in later versions) but Excel had some trouble reading some fields so I thought I'd see what PowerPivot can do.

    Joshua

  2. #2
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    You have to connect them through connection manager.

    Data tab in Excel connect to the database file using MS Query or OLE DB.

    This will bring the data in and then you can manipulate. In the power pivot tab you should have a data connection feature. I think the power pivot tab you can go from database and select the dBase file. This will recognize the full database and then you can pull in the tables you want for your query.

Posting Permissions

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