dbf

  1. A

    Help improve .DBF import speed

    I am working on a project to automate importing multiple .dbf files into a single excel sheet. The idea being I can import a group of .dbf files representing one dataset and the trend/graphs I need are automatically generated. The .dbf files always have the same data columns/header (38 columns)...
  2. B

    Import .dbf file, and process its contents.

    Hi guys ! I am new to excel programming, yet I have work to be done, so if you could help me out it would be well appreciated. I have several .dbf files, and they look like this in excel: <tbody> <tbody> 401003 </tbody> <tbody> EUR </tbody> <tbody> 10 </tbody> <tbody> 2019.04.01...
  3. R

    Excel to DBF file conversion

    Hi, I am using MS Excel - 2007. I've to convert Excel file to DBF file. How to do this? Can any one please help?
  4. L

    Can't open DBF file in excel, but will open in Open Office?!?

    Can any one shed any light on why this DBF file will not open in Excel but will open in OpenOffice Calc? <a href=http://www.filedropper.com/lmjmpickhis><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial...
  5. L

    Excel Newbie Question: .dbf file import help - 1 mil+ rows

    Hi: I am trying to import a .dbf file into excel. I saved it to my desktop and it says it's 372 MB - compressed size 56 KB. So, I imported, but there are more than 1 million rows, so I can only see part of the data. Can someone tell me how to import 1 million records at a time, so I...
  6. M

    Import multiple .dbf files into one file

    I have hundreds of .dbf files which I want to combine into one file. How can I do this process (without doing it one at a time)?
  7. J

    Trouble looping through .dbf files

    So I'm banging my head against the wall trying to run a macro that generates a new worksheet for every .dbf file in specified directory and then copies ranges of data. The code works great for the first file but then gets hung up on that first .dbf and never advances to the subsequent files. I'm...
  8. S

    Plugin for DBFs?

    Excel 2010 does not have dbf as a possible file format. Is there anyway to add it? I know almost no-one uses DBFs anymore, but they are still used in shapefiles for mapping programs. I can use open office, but I would prefer to use excel for everything, rather then switch back and forth...
  9. T

    ASCII characters in DBF file

    I need to add trademark and registered trademark ASCII characters to a DBFIII database. The DBF file gets opened in Excel. An ASCII code (alt+0153 for trademark) is inserted and displays correctly. But, when the file is saved and re-opened, the 'TM' is a question mark. What combination of keys...
  10. L

    Pivot Table Dbase IV

    Hello, I have several files that I've downloaded in Dbase IV format. They are larger than 65,536 lines so I would like to pivot them directly from the Dbase IV format. How do I go about doing this? I went into external source and clicked on dbase, but for some reason my .dbf file didn't...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top