![]() Which will be significant, there are a number of repeating fields that need to be normalised into child tables.Īs I see it there are a few different options, most of which involve either connecting to to FMP over ODBC and using an intermediate to copy the data across (either custom code or MS Acess linked tables), or, exporting to flat file format (CSV with no header or xml) and either use excel to generate insert statements or write some custom code to load the file. the problem I have is how to export the data to a real database (SQL Server) so I can work on data quality and normalisation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |