Home > Archive > Getting Started with dBASE > March 2006 > Save as XLS file









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Save as XLS file
eric wu

2006-03-24, 8:24 pm

in DBF version 3 or 4 tables, I can easily use this command

USE myTable
COPY TO myTable.xls

to convert DBF to an XLS file ( For MS-Excel )
but I can't use the same commmand for a version7 table

Can somebody guide me what is the easiest way to translate my version-7
table to an XLS file ?

Eric Wu


Gerald Lightsey

2006-03-25, 3:24 am

On Fri, 24 Mar 2006 14:14:42 -0600, in the dbase.getting-started group,
eric wu said...
> Can somebody guide me what is the easiest way to translate my version-7
> table to an XLS file ?


dQuery.

Gerald
eric wu

2006-03-25, 9:24 am

Thanks but what I want is to write a "output to Excel" function in my
program.
how to code

"Gerald Lightsey" <glightsey1@cox.net> wrote in message
news:MPG. 1e8e85418bde319d9898
a5@news.dbase.com...
> On Fri, 24 Mar 2006 14:14:42 -0600, in the dbase.getting-started group,
> eric wu said...
>
> dQuery.
>
> Gerald



Ken B

2006-03-25, 1:24 pm

Take a look at the exportdata.wfm in the dUFLP. There is an ExcelOut method
that should do what you want.


Walter Heinze

2006-03-27, 9:24 am


The result is no excel-table when use "COPY TO myTable.xls"
It's a dBase-Table

Walter Heinze

eric wu Wrote:

> in DBF version 3 or 4 tables, I can easily use this command
>
> USE myTable
> COPY TO myTable.xls
>
> to convert DBF to an XLS file ( For MS-Excel )
> but I can't use the same commmand for a version7 table
>
> Can somebody guide me what is the easiest way to translate my version-7
> table to an XLS file ?
>
> Eric Wu
>
>


eric wu

2006-03-28, 3:24 am

ok thanks,
i guess there's no any other esay way.....


"Ken B" <bogus@nowhere.com> wrote in message
news:MWJvASDUGHA.2016@news-server...
> Take a look at the exportdata.wfm in the dUFLP. There is an ExcelOut
> method that should do what you want.
>
>



eric wu

2006-03-28, 3:24 am

however, you can use Excel to open that myTable.xls directly




"Walter Heinze" <heinze@dreid.de> wrote in message
news:gAhPrmaUGHA.560@news-server...
>
> The result is no excel-table when use "COPY TO myTable.xls"
> It's a dBase-Table
>
> Walter Heinze
>
> eric wu Wrote:
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com