Jump to content

emtodell

Newbies
  • Posts

    5
  • Joined

  • Last visited

Everything posted by emtodell

  1. Kraftyman, Thanks so much for taking the time to explain, and yes, your explanation actually makes sense to me! I did wind up having to split up some of the fmp files, keeping a field called "recordno" with each split. The next challenge is making the tables in Access relational, but tech guy said he'd help w/ that. Thanks again, Ellen
  2. Okay, for anyone who cares... I have finally connected my dbs using ODBC! The only way it worked is if I reduced the number of fields in my FMP to 32 fields. Kraftyman's message tipped me off as to the number of fields I could use. Does anyone know why this is? Ellen eodell@sewanee.edu
  3. bbaliner, Thanks! I did that and now I can actually see my files, but even though I've gotten rid of the indexing in the filemaker dbs, Access keeps telling me that "There are too many indexes on table 'VtQoDefTemp0000'. Delet some of the indexes on the table and try operation again." Harumph! Ellen eodell@sewanee.edu
  4. Kraftyman, Thanks for the help! Okay, now, how do I enable sharing of the filemaker database via the local or remote data access companion? We are on a local network if that helps. I did do all of the other steps, but the Filemaker db did not appear when I chose the ODBC source in step 13 & 14. So, I'm guessing that has something to do w/ not enabling the file sharing. I'm going to do some digging while I anxiously await your response. Thanks again. Oh, under the ODBC Data Source Administrator, there are 7 tabs to choose from when I "add." Am I "adding" under "User DSN" tab? This is step 5. Ellen
  5. 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
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.