Automatically create table, define fields

[Mandu]

I'm looking for a way to automate the process of creating a Table and defining its Fields.

Purpose is to be able to take a CSV file where Record 1 contains column names, and to create a table with those fieldnames (all Text fields) and then import the CSV file.

I'm doubtful it can be done (there isn't an AppleEvent to create fields) but the ingenuity on this list knows no bounds.

Thanks,

Chap

[Raybaudi]

Hi

give a try... drag and drop that file over the FileMaker app icon :(

[Fenton]

Just remember to check the box where it asks if the 1st row contains the field names. It is in both the Open and Import dialogs.

[Mandu]

Wow!

Thanks, Raybaudi and Fenton. Exactly what I wanted.

Chap.