Hi there,
I just converted (in the process of)to A5 from A4v6. I have a very complicated Excel spreadsheet which I effectively duplicated in A4. My normal procedure would be to get everything correct in the spreadsheet, then save the spreadsheet as a DBF file.
The DBF file contained the exact field names as the A4 database, so I could tell A4 to match up the fields by field name. I only appended fields that were not calculated in A4. I would then filter down to the "just appended" records and re-calculate them. This procedure worked flawlessly in A4 every time. (My database always calc'd out to the same result as the spreadsheet.)
When I tried to do this in A5, I saved the spreadsheet to DBF as normal, then I added the DBF to the A5 database. I then tried to run an "Append Operation" to append the records to the main table.
When I ran the Append operation, it errored out and said that some field types were not matching. A4 always took the data and converted it to A4 data types. (For instance, date fields came in as text and A4 converted them to dates.)
If anyone followed the whole post above, my question is: What is the best way to append data in A5? Has anyone else ever tried this sort of thing? Is there a better way to do it?
Thanks,
George
I just converted (in the process of)to A5 from A4v6. I have a very complicated Excel spreadsheet which I effectively duplicated in A4. My normal procedure would be to get everything correct in the spreadsheet, then save the spreadsheet as a DBF file.
The DBF file contained the exact field names as the A4 database, so I could tell A4 to match up the fields by field name. I only appended fields that were not calculated in A4. I would then filter down to the "just appended" records and re-calculate them. This procedure worked flawlessly in A4 every time. (My database always calc'd out to the same result as the spreadsheet.)
When I tried to do this in A5, I saved the spreadsheet to DBF as normal, then I added the DBF to the A5 database. I then tried to run an "Append Operation" to append the records to the main table.
When I ran the Append operation, it errored out and said that some field types were not matching. A4 always took the data and converted it to A4 data types. (For instance, date fields came in as text and A4 converted them to dates.)
If anyone followed the whole post above, my question is: What is the best way to append data in A5? Has anyone else ever tried this sort of thing? Is there a better way to do it?
Thanks,
George
Comment