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


> > You have the code. You can debug yourself. No need to rename something when you don't know what you are renaming. Your rename column code is wrong, should use & there.
> >
> >
> >

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

> > Support Wikipedia
>
> 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

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