Auto entry to imported numbers file
1) If I have data in a numbers file of which there are 3 tables, how do I import just one table,
2) When importing this table how do I assign an individual number to each row?
I'll answer 2 but am not sufficiently familiar with Numbers to have an answer for 1...
Do not use the "new table" option when importing your data. You'll need to set up the table and define fields for every column of spreadsheet data first. Then add a field that is set up in field options to auto-enter a serial number.
When you use import records to import your data, a small dialog will pop up just before the importing starts that has a check box for enabling auto-enter options. Select that option.
Thanks, but no numbers appeared in my new field __PKItemID
Many thanks, this solved it.
The results you show are what you get when you don't select the check box for enabling auto-enter options.
Retrieving data ...