I have a mysql database I'd like to connect to. Currently there is no way for arcgis pro to use an odbc connection to mysql. The issue we are faced with is if we export/write a table to a csv and then import the csv to an fgdb table I lose records. Not sure how or why. If I convert it to an xls first and then do an excel to table the same thing happens. One of the issues we face is there are date fields with null values or blank values; when converting from csv or excel to fgdb table, those values that are not null or blank get converted to the Microsoft serial numbers, not dates the rest of understand so there is more conversion to do.
Long story short; with data interoperability can I connect to mysql and convert the tables there in a fgdb table and not lose data?
