PC Review


Reply
Thread Tools Rate Thread

Cannot open the DBF created from the SaveAs option of Excel

 
 
DPM
Guest
Posts: n/a
 
      24th Jul 2008
Hi,

I have an Excel sheet with 150 columns and 8 rows of data, when I use the
SaveAs option under the File menu of Excel with Type DBF4, it creates the
dbf file with no errors. But when I try to open the file from VFP, it
indictaes the following error and cannot be opened.
"Table 'H:\Book11.dbf' has become corrupted. The table will need to be
repaired before using again."

But if I reduce the width of the columns in the Excel and then save it as a
DBF, it is possible to opend the table even with 150 columns from VFP.
The limit in VFP is a max. of 254 fields and max. no. of characters per
record is 65500.

Further figured out that the DBF created from Excel can have a maximum of
3999 characters for it to be opened from VFP.

I am using MS Excel2003(11.6560.6568) SP2 and VFP9 SP1
Even programmatically using the Excel.SaveAs() from VFP causes the problem
Each column in the Excel sheet is 27 points when it fails, but with 26
points it suceeds.

Could someone please advice how to avoid this problem and create a DBF with
data from Excel.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open the DBF created from the SaveAs option of Excel DPM Microsoft Excel Discussion 2 24th Jul 2008 10:57 AM
Cannot open the DBF created from the SaveAs option of Excel DPM Microsoft Excel Discussion 0 24th Jul 2008 08:37 AM
Open Excel with a XML file and SaveAs XLS =?Utf-8?B?TGkgUGFuZw==?= Microsoft Excel Programming 0 3rd Jul 2006 10:17 PM
Can'nt open excel worksheet (created in excel 2002) in excel 2003 =?Utf-8?B?Z29sYWJp?= Microsoft Excel Crashes 0 20th Jun 2006 10:08 AM
Excel Open, Close, Save, SaveAs Arguments in VBScript Mark Ritchey Microsoft ASP .NET 0 10th Dec 2003 03:18 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:09 AM.