FPW 2.6 application.

I am trying to import some data from Excel spreadsheet. The syntax I use is as
follows...

Append from Test.xls type xls

Maybe I am having the syntax wrong since this gives me an error 'Invalid Excel
format' or some such message. I tried the same syntax with quote across the
file names but does not work.. What am I doing wrong?

Thanks in advance...

Hi Shah,

I haven't imported from Excel in FPW for a while but I do know that the file
formats in Excel have changed since FPW. The current default is the Excel 97
format which I think is Excel 8. Try a Save As in Excel and save to one of
the older formats until you find one that works.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (AT) mvps (DOT) org, www.cindywinegarden.com

"ShahJagat" <shahjagat (AT) aol (DOT) com> wrote

I tried that too and it gave me the same message. Finally I had to save the
Excel worksheet as a text file and then 'Append from text file tab delimited...

Wish I could append directly from Exel without having to go thru the additional
step