I don't know your data, and what it is you're importing, or how you want to get it out again – but at a guess, these headings should go as data into a “category” field.
Maybe describe the data in more detail?
I think what OP is looking for is a way to set the field names to the value in the first row of the csv on an import records to new table. Rather than having f1, f2, f3... as the default field names.
In this case there is no heading row and Alabama is set as the field name with all other states in that field. Not the best example but hope it helps.
You select import to new table for the Target and check the box in the lower left "Don't import first record (contains field names).
"set the field names to the value in the first row of the csv on an import records to new table. Rather than having f1, f2, f3... as the default field names."
yes, this is exactly what I am after.
if all the field names match the first row of my csv then i can use the "matching names" option.
But how do I set the field names to the first row of the csv?
I dont quite get where that is done in the last 2 posts you put up.
It sets automatically using the import dialog as I have shown in the attached photo.
To get to this dialog:
File>Import Records>From File-->select the file and set the setting as shown.
I did not mention this but make sure to use "match field name" setting as well. In the screen shot the names on the left are from the CSV and the ones on the right are the new field names in the FM table.
It is more simple than it appears.
bigtom's screen shot doesn't actually show "Column Names", but the other settings are correct on the dialog.
Create a new table ("Target" - upper right, your filename)
Matching Names ("Arrange by")
Add new records (selected)
Don't import first record... (selected)
If you have column names in your file to import, then those settings will use the first row will be the new field names.
much simpler then I thought it would be,
ill give it a go