Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Importing Excel sheets using Foxpro

Posted on 2006-04-10
4
Medium Priority
?
374 Views
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?

thnx
0
Comment
Question by:HJohnson
  • 2
  • 2
4 Comments
 
LVL 33

Accepted Solution

by:
CarlWarner earned 500 total points
ID: 16422214
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
http://support.microsoft.com/kb/319277/en-us

How To Append Data from a Single Sheet of an Excel Workbook
http://support.microsoft.com/kb/176894/en-us
0
 
LVL 1

Author Comment

by:HJohnson
ID: 16422308
APPEND seems to be the way to go.   Thnx for the help.  
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 16422341
No problem.  

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

Author Comment

by:HJohnson
ID: 16423193
That's my eventual goal   :)   thnx
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Introduction to Processes

579 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