Re: Updating a linked Table field from Short Text to Date
you could create a template table, and read the data into that table. If that fails, then import the data as at present, add another date field, and update the new field with the converted dates.
As TheDBGuy says, it's maybe worth inspecting the spreadsheet to understand what's going on. If dates in the table are badly formed, it will import as text
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.