11/5/2023 0 Comments Carriage return in excel for mac(pseudocode): cursor.execute("insert into products(id, name) values (?, ?)", productID, productName) The right way to migrate your data into those tables would be to use ODBC calls to your new database, passing the original data as parameters to your INSERT statements, e.g. The only task you should write an SQL script for is to create the database and its tables the DB structure is fixed so safe and easy to hardcode. You wouldn't be trying to code munge data in your Excel spreadsheet into a gigantic SQL script? If so, that's just a ton of data corruption and other accidents waiting to happen. While getting the hell away from FMP is always to be applauded, the way in which you're doing it sounds rather horrific.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |