Importing Excel sheets using Foxpro

Posted on 2006-04-10
Last Modified: 2006-11-18
Visual Foxpro v6
Windows XP

I'm trying to import an excel spreadsheet using the "import from" command in Foxpro, but I've discovered that the import will drop any columns that are blank.  How can I preserve these blank columns?

Question by:HJohnson
    LVL 33

    Accepted Solution

    I believe that may have been a bug that wasn't detected/fixed until VFP7 SP1.  Since you haven't upgraded, you may have to live with it if you insist on staying with a last century version of VFP and using IMPORT FROM.  Maybe APPEND will have a different and better end result for you.

    FIX: IMPORT from Excel File Causes Error

    How To Append Data from a Single Sheet of an Excel Workbook
    LVL 1

    Author Comment

    APPEND seems to be the way to go.   Thnx for the help.  
    LVL 33

    Expert Comment

    No problem.  

    I hope you can get to VFP9 SP1, the latest release of VFP from MS.
    LVL 1

    Author Comment

    That's my eventual goal   :)   thnx

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    either24  challenge 19 73
    linearIn  challenge 23 54
    factorial example challenge 10 44
    wordcount challenge 11 48
    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now