Importing FileMaker Pro to Excel?

[The Wolf]

I imported the database and formatted all the fields the way I wanted, i.e.
Percents, dollars, etc.

My question is the database will change and I want to re import from time to
time.

How can I keep my formatting in Excel?

What's the easiest way to handle this? Delete all data in Excel and re
import. Or is there a way that Excel will simply update what's changed?

--
==========================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint. In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
==========================================================================

 

[Jim Gordon MVP]

Hey Wolf,

Check out this article
Import FileMaker Pro files into Excel X
<http://www.microsoft.com/mac/products/excelx/using.aspx?pid=usingexcelx&typ
e=howto&article=/mac/LIBRARY/feature_articles/officex/xl_importFileMaker.xml
If it doesn't have the answer you need, please post a follow-up message.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[The Wolf]

On 11/19/2003 8:45 PM, in article (e-mail address removed),
"Jim Gordon MVP" <[email protected]> opined:

Thank you! That article answered my question.

 

[The Wolf]

On 11/20/2003 11:24 AM, in article BBE25509.46940%[email protected],
"The Wolf" <[email protected]> opined:




Jim,

One small glitch, perhaps you can help.

In FileMaker Pro one field is 4/4, 8/4, #2 Pine, etc. The commas are not
part of the data.

In Excel the 4/4 comes in as 36253. I suspect it is trying to convert it to
a date.

I've tried formatting that column as "text" and it doesn't seem to change
back to 4/4. The #2 pine works ok.

On 11/19/2003 8:45 PM, in article (e-mail address removed),
"Jim Gordon MVP" <[email protected]> opined:

Thank you! That article answered my question.

--
==========================================================================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint. In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
==========================================================================

 

[Jim Gordon MVP]

Hi

Excel keeps track of dates using a serial number. The first day for
Macintosh Excel is day zero, which is January 1, 1904. Day number 365253 is
April 4, 2003. To see this effect format the cell as a date from the Format

Cells dialog box.

Extensive information about using date formats is included in Excel's help
file. You can also check the manual (it's a PDF file on the install CD) for
additional formatting suggestions.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[The Wolf]

On 11/20/2003 7:34 PM, in article uiP#2A#[email protected],
"Jim Gordon MVP" <[email protected]> opined:

The problem is the data in FileMaker Pro is not a date.

It is 4/4 (which means four quarter) and 8/4 (which means eight quarter)
Excel returns 365253. So as you say Excel thinks the data in FMP is April 4.
How do I make Excel think the data is simply 4/4?

Perhaps I'm not being clear, sorry.

Hi

Excel keeps track of dates using a serial number. The first day for
Macintosh Excel is day zero, which is January 1, 1904. Day number is
April 4, 2003. To see this effect format the cell as a date from the Format

Cells dialog box.

Extensive information about using date formats is included in Excel's help
file. You can also check the manual (it's a PDF file on the install CD) for
additional formatting suggestions.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[Bernard Rey]

The problem is the data in FileMaker Pro is not a date.

It is 4/4 (which means four quarter) and 8/4 (which
means eight quarter) Excel returns 365253. So as you say
Excel thinks the data in FMP is April 4.
How do I make Excel think the data is simply 4/4?

The standard way to have Excel considering it as text is
to use the Excel import wizard. on the third pane, select
the considered colum and set the format to text (it's a
button on the upper right).

Does this answer your question or do you use another way
to import the data?

 

[The Wolf]

The standard way to have Excel considering it as text is
to use the Excel import wizard. on the third pane, select
the considered colum and set the format to text (it's a
button on the upper right).

Does this answer your question or do you use another way
to import the data?

No, I am using the wizard and when I try to format a column to text it
returns 365253 instead of 04-Aug or whatever.

Sorry if I'm not communicating the problem clearly, I am a newbie.

All I want it to do is import 4/4 as 4/4 and 8/4 as 8/4. It done fine with
4' x 8'

 

[ekarr]

No, I am using the wizard and when I try to format a column to text it
returns 365253 instead of 04-Aug or whatever.

Sorry if I'm not communicating the problem clearly, I am a newbie.

All I want it to do is import 4/4 as 4/4 and 8/4 as 8/4. It done fine with
4' x 8'

Is there a reason you don't want to format it as a date? Because if you select
the column, go to Format, cells, and format the cells as date, with the first date
option (3/14), it will appear in the format you want (4/4, 8/4) and "#2 Pine"
will remain "#2 Pine".

 

[The Wolf]

Is there a reason you don't want to format it as a date? Because if you
select
the column, go to Format, cells, and format the cells as date, with the first
date
option (3/14), it will appear in the format you want (4/4, 8/4) and "#2 Pine"
will remain "#2 Pine".

THANK YOU! That works fine.

Michael