Alpha Video Training
Results 1 to 8 of 8

Thread: How can I convert .xls files to .dbf files

  1. #1
    Member
    Real Name
    Don Cromwell
    Join Date
    Jun 2006
    Posts
    34

    Default How can I convert .xls files to .dbf files

    I successfully converted A4v7 to Win 8.1 using DosBox. One of those files has to be updated on a weekly basis, and for the past "x" years, I have used a 2003 Excel to do the job. The .dbf file was imported into Excel, modified and then resaved as .dbf. However, in the upgrade to 8.1, the old Excel software would not run so I had to put in Excel 2010. Just found out that the 2010 Excel will not save data into .dbf. I worked about this by saving the new data in Excel 2007 format, which 2010 Excel will do, and downloading it into a thumb drive. Putting the thumb drive into the old machine, loading the data into the old 2003 Excel and then downloading it back to the thumb drive as .dbf. It works, however, not very efficient and very time consuming. It would be nice to have a conversion application in the new machine. Does any one know a conversion application that might do the job and will work????
    dsc

  2. #2
    Member
    Real Name
    Michael Cornford
    Join Date
    Oct 2011
    Location
    East Sussex, UK
    Posts
    884

    Default Re: How can I conver .xls files to .dbf files

    Check the Free version of Flowheater it has an OleDBAdapter no idea what that is.
    Flowheater is a brilliant program, if you buy a full version you can use scripts put them into batch files and then run them as scheduled tasks.
    I work on millions of records per day using 20 to 30 Flowheater batch files. Writing 100,000 records from a text file to MySQL with multiple indexes takes about 3 minutes.
    I use it with excel, text files, SQL, MS Access and ODBC but I don't use db files.

    Michael

  3. #3
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,607

    Default Re: How can I conver .xls files to .dbf files

    Will Excel 2010 save the spreadsheet in a version of excel that A4v7 can import?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  4. #4
    Member
    Real Name
    Michael Cornford
    Join Date
    Oct 2011
    Location
    East Sussex, UK
    Posts
    884

    Default Re: How can I conver .xls files to .dbf files

    Sorry not sure if this is to me.

    Yes Flowheater Can read Xlsx and save Xls no problem.
    Like any other routine it will overwrite etc if you tell it.
    You can set it to run as a batch file

    http://www.flowheater.net/

    Michael

  5. #5
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,607

    Default Re: How can I conver .xls files to .dbf files

    Quote Originally Posted by Michael1954 View Post
    Sorry not sure if this is to me.

    Michael
    Not necessarily directed to you only. Although I didn't ask about Flowheater, I asked about Excel.

    Just a thought of how this can be handled by Alpha using other Alpha options.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  6. #6
    Member
    Real Name
    Don Cromwell
    Join Date
    Jun 2006
    Posts
    34

    Default Re: How can I conver .xls files to .dbf files

    I checked out Flowheater Sat. Their site did mention dbf files in a rather indirect way. Will check further during business hours.

    Regarding A4v7 accepting other than dbf data files I do not believe so. Went through v6 manual and it said a4v7 was looking for the .dbf extension.

    Thanks for the suggestions

    dsc

  7. #7
    Member
    Real Name
    Michael Cornford
    Join Date
    Oct 2011
    Location
    East Sussex, UK
    Posts
    884

    Default Re: How can I conver .xls files to .dbf files

    Don

    The owner is a really nice German guy who normally answers with examples.

    I think his name is Robert; perfect English.

    Michael

  8. #8
    Member
    Real Name
    Keith George
    Join Date
    May 2000
    Location
    Near Penzance Cornwall UK
    Posts
    205

    Default Re: How can I conver .xls files to .dbf files

    Good Morning,

    For what its worth, I have in the past imported data into Alpha4v6, long strings of numbers then, through scripts, comma separated the string and saved, then imported as CSV.

    Excel (I think all versions) will save as CSV and Alpha4v6 can import CSV, I don't know if A4v7 can as I don't have that version..

    Good Luck,
    Keith

Similar Threads

  1. Entering the files names of all files in a directory, in a table field
    By MikeData in forum Alpha Five Version 11 - Desktop Applications
    Replies: 4
    Last Post: 07-14-2014, 09:36 AM
  2. Coordinating Development Files with Live Production Files
    By sgerber in forum Alpha Five Version 11 - Desktop Applications
    Replies: 26
    Last Post: 10-18-2012, 12:08 PM
  3. Replies: 11
    Last Post: 11-21-2008, 05:40 PM
  4. Convert Paradox .db files
    By bporter101 in forum Alpha Five Version 5
    Replies: 9
    Last Post: 12-15-2003, 11:21 AM

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
  •