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 20:45:27 +0000
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.