dbf

  1. 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...
  2. 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?
  3. 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...
  4. 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...
  5. 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)?
  6. 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...
  7. 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...
  8. 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...
  9. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top