It is my understanding that FIleMaker can import Bento data directly. Have you tried that approach?
Thanks for the reply.
The FileMaker Help file suggests that you can only do that on a Mac. I'm running FileMaker on a PC but I guess I could give it a try anyway. With backups I've got nothing to lose.
That would explain using the intermediary file...
Exactly which method are you using to import this data from the csv or xls file? (You might drag and drop the file, Import records with the New table option or import records specifying an existing table...)
If all else fails, adding a date field after the fact and using replace field contents to copy the text and convert enter it as a date into the added date field would be a fairly simple way to repair your imported data.
I tried both csv and xls. Neither maintained the date format properly.
So I installed FileMaker on my Mac and opened the Bento file. It converted it to a FM file and that worked fine. So then I opened the converted FM file in Windows and that worked fine. So I finally a Benot file to run correctly in FileMaker in Windows. A little round about but it worked.
Thanks for reminding me that FileMaker would open a Bento file. I knew that but your suggestion was what made me finally bother to install FileMaker on a Mac and do it.
Now on the next next learning experience as I figure out how to get this database to do everything I want to track students, teachers and classes in our online animation school.
I suggest that you post any such follow up questions in the FM Pro Forum instead of the FM Server Forum section. (See the tabs at the top of this screen.)
Posts to the FM Pro Forum will be seen by a lot more people so you are more likely to get help quickly there than here.
Thanks for your help!