Re: Problems with exporting for use in MS Excel 97

#1

Quote:

When I try to export an fm pro file to wk1, dif or csv-format to use it in
MS Excel 97, it works very fine, except when I'm opening this file with
Excel and I look in the tables, I'll noticed that from a series records
with
the same name only the first row shows the name, the following rows left
the
same data away. An example:

I alway use *.dbf or *.slyk for exporting to Excel!

Greetz,

Bigfoot

#2

Dear Group,

No matter what I do, no matter what kind of expormat I use (including .sylk
en .dbf) the result is always the same ... In Exel 97 (Windows) the records
show always the first record within the column when the there is a series of
the same data.

I need urgent help to solve this problem !!! :-((

Danny

"Bigfoot" <pit.nospam (AT) nlr (DOT) nl> schreef in bericht
news:betrim$dc8t$1 (AT) simian (DOT) nlr.nl...

Quote:

When I try to export an fm pro file to wk1, dif or csv-format to use it
in
MS Excel 97, it works very fine, except when I'm opening this file with
Excel and I look in the tables, I'll noticed that from a series records
with
the same name only the first row shows the name, the following rows left
the
same data away. An example:

I alway use *.dbf or *.slyk for exporting to Excel!

Greetz,

Bigfoot

#3

Have you tried exporting as a Lotus 123 file. Excel imports those in pretty
cleanly.

Matt Revenaugh

- - - - - - - -

On 7/23/03 2:43 AM, in article bfllcp$4ju$1 (AT) naxos (DOT) belnet.be, "Danny"
<Nospamdpi110160 (AT) hotmail (DOT) comNospam> wrote:

Quote:

Dear Group,

No matter what I do, no matter what kind of expormat I use (including .sylk
en .dbf) the result is always the same ... In Exel 97 (Windows) the records
show always the first record within the column when the there is a series of
the same data.

I need urgent help to solve this problem !!! :-((

Danny

"Bigfoot" <pit.nospam (AT) nlr (DOT) nl> schreef in bericht
news:betrim$dc8t$1 (AT) simian (DOT) nlr.nl...
When I try to export an fm pro file to wk1, dif or csv-format to use it
in
MS Excel 97, it works very fine, except when I'm opening this file with
Excel and I look in the tables, I'll noticed that from a series records
with
the same name only the first row shows the name, the following rows left
the
same data away. An example:

I alway use *.dbf or *.slyk for exporting to Excel!

Greetz,

Bigfoot

#4

Danny <dpi110160 (AT) hotmail (DOT) com(Nospam)> wrote:

Quote:

with
the same name only the first row shows the name, the following rows left the
same data away

it's because you were sorting by the first field

it's not a bug, it's a feature, but a very ennoying one

if anyone knows how to do...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Problems with exporting for use in MS Excel 97

comp.databases.filemaker comp.databases.filemaker

Re: Problems with exporting for use in MS Excel 97 - 07-14-2003 , 04:02 AM

Re: Problems with exporting for use in MS Excel 97 - 07-23-2003 , 04:43 AM

Re: Problems with exporting for use in MS Excel 97 - 07-23-2003 , 10:09 AM

Re: Problems with exporting for use in MS Excel 97 - 07-31-2003 , 06:11 AM