Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: convert to excel
Thread ID: 209386 Message ID: 209575 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Monday, December 29, 2008 5:32:00 PM         
   


> hi all,
>
> LOCAL oExcel,ix,lcCursorName
> LOCAL ARRAY sheetNames[18]
> Select *;
>     from ('t1') ;
>   into Cursor crsToExcel1 ;
>   nofilter
> 

> 

>
> thanks


In the command
Select *;
    from ('t1') ;
  into Cursor crsToExcel1 ;
  nofilter

't1' is the actual name of a table, not a variable, so the ( ) are not needed. Use
 SELECT * FROM t1 INTO CURSOR crsToExcel1
*or  
  SELECT* FROM "t1" INTO CURSOR crsToExcel1
*I you use a variable you have to use (variable)
x ="T1"
 SELECT * FROM (x) INTO ...

-Anders

ENTIRE THREAD

convert to excel Posted by mohammed qasem @ 12/28/2008 9:00:54 AM
RE: convert to excel Posted by tushar @ 12/28/2008 10:00:08 AM
RE: convert to excel Posted by Anders Altberg @ 12/29/2008 5:32:00 PM