Hi, I'm relatively new to FMPro, so pls. bear w/ me. And by-the-by, for all of you die-hard FMPro fans, it is Not My Decision to leave FMPro - that decision was made by our tech guy.
I'm using Windows 2000 Professional I have this straight-up db in 5.0 - nothing fancy about it, and I'm looking to export the records and get them into Access 2000. I do have a trial copy of FMP 5.5 and our university may actually be buying 5.5 in the very near future.
There are 58 fields and 4800 records in the db. When I export as .csv, the field names are eliminated (very irritating) and when I import the records into Access I wind up w/ the table and a table of errors. When I export as .dbf, the field names are truncated (not quite as annoying), and the fields themselves are limited to 254 characters (this may or may not be a problem).
Our tech guy started mumbling something about an ODBC driver for FileMaker 5.0. I'm not real familiar w/ ODBC and why having that driver would be helpful. Tech guy is wicked busy, so I'm trying to pitch in w/ my limited knowledge and willingness to learn. So, I'm looking for a clean way to get the data into Access w/o having to fix fields and errors.
Many thanks in advance,
Ellen
eodell@sewanee.edu