Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Excel Multi Sheet to Multi dbf
Thread ID: 344882 Message ID: 345077 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Thursday, May 17, 2012 9:29:20 PM         
   


> >
> > Rename Column code working as i required .
> >
> > I have Excel 2003 file with 24 MB, it takes only 30/40 Seconds to generate the cursor.
> > I have Excel 2007 file with 8 MB, it takes 4/5 minutes to generate the cursor ?
> >
> >
> > Warm Regards,
> > mk.
>
> How would I know what may be the reason? Excel 2007 file is a zipped file so are you sure it doesn't correspond to 80 - 800 Mb Excel 2003 file? Is that the same data? Are you using ACE driver for Excel 2007? Maybe upload data to somewhere like hotfile, rapidshare ... and give link.
>
>

> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
> Blog (mirror) - sounds to be down
>

> Support Wikipedia

Yes ACE for Excel 2007 and JET for Excel 2003.Saveas Excel2003 Increased the size of the file .

DO CASE
CASE '.XLSX'$UPPER(lcDataSource)
* Excel2007
   lcConStr = ;
   'Provider=Microsoft.ACE.OLEDB.12.0;'+;
   'Data Source='+m.lcDataSource+';'+;
   'Extended Properties="Excel 12.0;HDR='+;
   IIF(m.lFirstRowHasHeader,'Yes','No')+'"'
OTHERWISE
* Excel97-2003
   lcConStr = ;
   'Provider=Microsoft.Jet.OLEDB.4.0;'+;
   'Data Source='+m.lcDataSource+';'+;
   'Extended Properties="Excel 8.0;HDR='+;
   IIF(m.lFirstRowHasHeader,'Yes','No')+';IMEX='+;
   IIF(m.lReturnAllAsText,'1','0')+'"'
ENDCASE


Warm Regards,
mk.

ENTIRE THREAD

Excel Multi Sheet to Multi dbf Posted by mk sharma @ 5/15/2012 9:42:30 AM
RE: Excel Multi Sheet to Multi dbf Posted by Anil Sharma @ 5/15/2012 10:28:47 AM
RE: Excel Multi Sheet to Multi dbf Posted by mk sharma @ 5/15/2012 7:52:08 PM
RE: Excel Multi Sheet to Multi dbf Posted by tushar @ 5/15/2012 10:49:37 AM
RE: Excel Multi Sheet to Multi dbf Posted by Cetin Basoz @ 5/15/2012 11:30:33 AM
RE: Excel Multi Sheet to Multi dbf Posted by mk sharma @ 5/16/2012 12:01:34 AM
RE: Excel Multi Sheet to Multi dbf Posted by Cetin Basoz @ 5/16/2012 4:44:16 PM
RE: Excel Multi Sheet to Multi dbf Posted by mk sharma @ 5/16/2012 8:45:00 PM
RE: Excel Multi Sheet to Multi dbf Posted by Cetin Basoz @ 5/17/2012 2:18:17 PM
RE: Excel Multi Sheet to Multi dbf Posted by mk sharma @ 5/17/2012 9:29:20 PM