Message
From
25/01/2017 06:25:21
To
24/01/2017 17:26:59
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2016
Network:
Windows Server 2016
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
ID da thread:
01646970
ID da mensagem:
01646996
Views:
54
>Hi Cetin,
>
>Thanks, but I decided to go with Michel's SQL idea.
>But I'd like to replace the 'copy (filename) to xl5.' Can I use this code? Is there anything you'd change?
>
>Luke
But the one I sent is already based on SQL idea :) SQL is the easy part, sending the result to excel is the tricky part.
You cannot use copy to with Excel anymore (unless you mean simple, small tables that copy to can handle too). The code I sent works with even for 64 bits excel.
PS: That code with slight modification also works with cursor(s).
>
>Thanks, but I decided to go with Michel's SQL idea.
>But I'd like to replace the 'copy (filename) to xl5.' Can I use this code? Is there anything you'd change?
>
>Luke
But the one I sent is already based on SQL idea :) SQL is the easy part, sending the result to excel is the tricky part.
You cannot use copy to with Excel anymore (unless you mean simple, small tables that copy to can handle too). The code I sent works with even for 64 bits excel.
PS: That code with slight modification also works with cursor(s).
Çetin Basöz
The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses
LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses
LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad