Re: Importing Data from Excel to Filemaker
Re: Importing Data from Excel to Filemaker
- Subject: Re: Importing Data from Excel to Filemaker
- From: email@hidden
- Date: Fri, 14 Feb 2003 16:00:23 -0600
Unfortunately, because of the goofiness of this spreadsheet, it won't
convert or import properly into FMP.
I want to write an Applescript that will simply copy from the
appropriate Excel cells, and paste into the appropriate FMP fields
one at a time. I'm not an experienced Applescripter. It sounds
simple, and it works flawlessly the other way around (FMP to Excel),
but there seems to be some data conversion issues from Excel to FMP.
Can anyone give me some sample code on how to write this?
Thanks
At 13:53 -0600 14/2/03, email@hidden wrote:
How to I convert data from Excel so that it will paste into
Filemaker. I get errors of "data type" or class.
Thanks
I don't know what version of FileMaker you are using, but from at
least v5.5 onwards all you need to do is open an Excel file from
within FMP (choose "Excel" from the file type in the Open dialog
box) and it will automatically convert into a FileMaker file.
If you have several worksheets in your .xls, FileMaker will ask you
which worksheet you want to convert. If you want to include data
from more than one worksheet you will have to either open the Excel
file again and choose the next worksheet and create a new FMP file,
or import the data into the file created from the first worksheet
you have already made.
You can also import Excel data into an already created FileMaker
file so long as you have the fields into which you want to paste the
Excel data.
The Excel data creates/imports as a matrix so that column heads
become field names and each row of data becomes a new record. FMP
will ask you if the first row is column heads or data. If you do not
have column heads, just data, FMP will automatically call the fields
f1, f2, etc. and the first row will be the first record.
hth
Oz
--
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.