Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Madan Mohan_DELHI
  Where is Madan Mohan_DELHI?
 Delhi
 India
 Madan Mohan_DELHI
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Import from VFP Tables to Excel/CSV
Thread ID: 372324 Message ID: 373788 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Wednesday, March 27, 2013 4:57:19 AM         
   


> >
> > Hi Cetin,
> >
> > The table headers seperated by comma is spliting into next line. Data from one record is also coming in two or more lines in CSV file when I see in notepad. Is there any way out that per record shows in single line in CSV file? Appreciate your or Anders help. My tables has more than 100 columns or so.
> >
> > Thanks,
> > Madan
>
> Notepad is not a nice editor to check those files. Anyway turn wrap off.
>
>

> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
>

> MongoDb Certified Developer
> MongoDb Certified DBA
>

> Support Wikipedia


Thank you Cetin, I am almost done but only one issue is there that for every single DBF VFP2Excel ask for where to Save file. The only change I have done is the following

lnombre = destd+[&xlsname]+".CSV"
Erase (lnombre)
oExcel.ActiveWorkBook.SaveAs(lnombre, 24)

Actually MS DOS CSV is required so I added 24.

Can we Wrap off programatically?

Need your help on this.

Thanks & Regards,
Madan

ENTIRE THREAD

Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/7/2013 2:46:47 PM
RE: Import from VFP Tables to Excel/CSV Posted by Cetin Basoz @ 3/7/2013 4:11:46 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/25/2013 12:49:09 PM
RE: Import from VFP Tables to Excel/CSV Posted by Cetin Basoz @ 3/25/2013 1:05:00 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/25/2013 1:27:22 PM
RE: Import from VFP Tables to Excel/CSV Posted by Anders Altberg @ 3/25/2013 1:43:30 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/25/2013 1:56:13 PM
RE: Import from VFP Tables to Excel/CSV Posted by Anders Altberg @ 3/25/2013 4:52:23 PM
RE: Import from VFP Tables to Excel/CSV Posted by Cetin Basoz @ 3/25/2013 3:32:30 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/26/2013 12:08:06 PM
RE: Import from VFP Tables to Excel/CSV Posted by Tore Bleken @ 3/26/2013 12:17:01 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/26/2013 12:26:14 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/26/2013 12:32:55 PM
RE: Import from VFP Tables to Excel/CSV Posted by Tore Bleken @ 3/26/2013 12:52:14 PM
RE: Import from VFP Tables to Excel/CSV Posted by Cetin Basoz @ 3/26/2013 8:19:13 PM
RE: Import from VFP Tables to Excel/CSV Posted by Madan Mohan_DELHI @ 3/27/2013 4:57:19 AM
RE: Import from VFP Tables to Excel/CSV Posted by Cetin Basoz @ 3/27/2013 10:35:39 AM