Postal code

Is there somebody who nows how to import a postal code in xls format so that
i have a postalcode list, thnks

Re: Postal code

ikke wrote:
> Is there somebody who nows how to import a postal code in xls format so that
> i have a postalcode list, thnks

If you have an existing file:
File > Import > FileType: Excel

Or just create a new file:
File > Open File > FileType: Excel

Re: Postal code

"Howard Schlossberg" schreef in bericht
news:13nq9chint3le9f@corp.supernews.com...
> ikke wrote:
>> Is there somebody who nows how to import a postal code in xls format so
>> that i have a postalcode list, thnks
>
> If you have an existing file:
> File > Import > FileType: Excel
>
> Or just create a new file:
> File > Open File > FileType: Excel

Thanks for your reaction, but how must I place the xls file in a table,
thats really the problem, i don't find anything about that in the users
manual. Thanks again

Re: Postal code

ikke wrote:
> "Howard Schlossberg" schreef in bericht
> news:13nq9chint3le9f@corp.supernews.com...
>> ikke wrote:
>>> Is there somebody who nows how to import a postal code in xls format so
>>> that i have a postalcode list, thnks
>> If you have an existing file:
>> File > Import > FileType: Excel
>>
>> Or just create a new file:
>> File > Open File > FileType: Excel
>
> Thanks for your reaction, but how must I place the xls file in a table,
> thats really the problem, i don't find anything about that in the users
> manual. Thanks again

If you have an existing table (because you've done it before or you
create a table and the desired fields manually). then you can just
import and you will have a chance to map the fields from the spreadsheet
to your data table as you go.

If you don't already have a table, then it will be easiest to add a row
at the top of your spreadsheet and type in your desired field names.
Save it. Then from FileMaker, go to File > Open, select Excel as the
file type, and point to your excel file, wherever it is. You will see
an option to ignore the first row because it includes only field names.
When you do this, FileMaker will create a new table with the field
names from the first xls row and then it will import the data.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance

Re: Postal code

"Howard Schlossberg" schreef in bericht
news:13nt2d5dfldog23@corp.supernews.com...
> ikke wrote:
>> "Howard Schlossberg" schreef in
>> bericht news:13nq9chint3le9f@corp.supernews.com...
>>> ikke wrote:
>>>> Is there somebody who nows how to import a postal code in xls format so
>>>> that i have a postalcode list, thnks
>>> If you have an existing file:
>>> File > Import > FileType: Excel
>>>
>>> Or just create a new file:
>>> File > Open File > FileType: Excel
>>
>> Thanks for your reaction, but how must I place the xls file in a table,
>> thats really the problem, i don't find anything about that in the users
>> manual. Thanks again
>
> If you have an existing table (because you've done it before or you create
> a table and the desired fields manually). then you can just import and you
> will have a chance to map the fields from the spreadsheet to your data
> table as you go.
>
> If you don't already have a table, then it will be easiest to add a row at
> the top of your spreadsheet and type in your desired field names. Save it.
> Then from FileMaker, go to File > Open, select Excel as the file type, and
> point to your excel file, wherever it is. You will see an option to
> ignore the first row because it includes only field names. When you do
> this, FileMaker will create a new table with the field names from the
> first xls row and then it will import the data.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg
> FM Professional Solutions, Inc. Los Angeles
>
> FileMaker 8 Certified Developer
> Member, FileMaker Business Alliance

Thanks, superbe you are !!