Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: Sandeep Misra
  Where is Sandeep Misra?
 Shelton
 Connecticut - United States
 Sandeep Misra
 Tags
Subject: RE: append data to a database
Thread ID: 112528 Message ID: 112577 # Views: 3 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, November 09, 2006 7:24:01 PM         
   


> Hi All,
>
> Please help me out with this.
>
> I am trying to append data from a XLS to DBF by executing the following command:
>
> Append from test.xls type xls
>
> It is executing properly when row count in the xls is less (~41). But when row count is 6133 (or any bigger number) it is showing the following error:
> "Microsoft Excel File Format is Invalid"
>
> Please let me know if i can eliminate this error in some way. At the same time please suggest if there is any alternative ways of doing the same.
>
> regards
> sandeep


If Ken's suggestion of using a type of XL5 doesn't work, there's also an XL8 option. If neither of those work, open the spreadsheet in NotePad and take a look at it. It might be plain ASCII. I had a situation recently where a client sent me a file with an XLS extension to be imported, but it turned out the file was actually a CSV file. Excel will display a CSV file just like it was an XLS file, so you can tell by how it looks in Excel.

-BP
www.peisch.com

ENTIRE THREAD

append data to a database Posted by sandeep misra @ 11/9/2006 11:48:07 AM
RE: append data to a database Posted by Ken Murphy @ 11/9/2006 12:52:40 PM
RE: append data to a database Posted by Barbara Peisch @ 11/9/2006 7:24:01 PM
RE: append data to a database Posted by Ken Murphy @ 11/9/2006 9:01:17 PM
RE: append data to a database Posted by Barbara Peisch @ 11/9/2006 10:18:02 PM
RE: append data to a database Posted by Ken Murphy @ 11/9/2006 10:21:34 PM
RE: append data to a database Posted by Barbara Peisch @ 11/9/2006 10:22:46 PM
RE: append data to a database Posted by sandeep misra @ 11/11/2006 2:07:12 PM
RE: append data to a database Posted by Ken Murphy @ 11/11/2006 3:31:43 PM