+ Reply to Thread
Results 1 to 3 of 3

Conversion of .xls file to dbase IV (.dbf) file WITHOUT MS ACCESS

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    59

    Conversion of .xls file to dbase IV (.dbf) file WITHOUT MS ACCESS

    Hey now,

    I currently use a program that favors dbf (dbase IV) files for custom applications and other needs.

    MS Excel 2003 had the functionality for saving of .xls files to .dbf files.

    MS Excel 2007 DOES NOT allow for this. I now have to go to MS ACCESS, import the .xls file, and before exporting it to a dbf file, Pray to No End that I will not get an error message such as "File Will Not Fit In Record" on the MS ACCESS format/dbf file or other error messages which I have to then attempt to solve through other means, especially since Microsoft Office Help does not address this issue directly.

    This does not happen all the time; I have had several instances where the xls file does go through MS ACCESS fine; it may be related to number of fields?

    BUT for the most part, when I do get the "Field will not fit in Record" error is make a copy of the .xls file, create a smaller spreadsheet with a couple of the only most program or function-relevant fields, go through the same procedure as above, which then generally works. (I then create another database later with an ID field that I can join to the function-relevant fields database).

    WHAT I WANT TO KNOW:

    Is there a way within MS ACCESS (or even Excel) where I do not have to go through this? Is MS EXCEL 2010 offering a version of what 2003 did?

    This is infinitely insane; I will die happy if MS Excel 2003 can become a part of my life again.

    Dan B

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Conversion of .xls file to dbase IV (.dbf) file WITHOUT MS ACCESS

    I did a quick search and found an open-source (free) Add-in for 2007 that enables dbf exporting.

    http://exceltodbf.sourceforge.net/
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    59

    Re: Conversion of .xls file to dbase IV (.dbf) file WITHOUT MS ACCESS

    Daffodil,

    Ok, good to know, but I may not be able to add applications like this to our operating system set up (Departmental Policy--have to get a Permission Slip first

    Dan b

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need VBA Help on MS-Access to generate report & save to xlsb file to tageted file
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2014, 07:52 AM
  2. [SOLVED] Saving Excel file in DBase IV format
    By CrawdadSolstice in forum Excel General
    Replies: 10
    Last Post: 07-02-2009, 01:54 PM
  3. Conversion Excel Spreadsheets to One Access File
    By Profiteer23 in forum Excel General
    Replies: 5
    Last Post: 02-07-2007, 12:53 PM
  4. [SOLVED] Error trying to close down dbase IV file used for input to excel
    By don in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2006, 09:40 PM
  5. Issues with opening DBF (dBase) file in Excel
    By EuroMaverick in forum Excel General
    Replies: 1
    Last Post: 02-15-2006, 12:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1