Accessions import-Huzzah, Lee!!!
March 14, 2007
Lee ended up reworking my data and I was able to load more than half of it. The other records were older and didn’t fit the scheme. I’ll mess with those individually.
Here are some the things I was doing wrong:
- I had some memo fields, they have to be text fields
- Contact info seemed to be causing a problem, so I ended up leaving it out
- When I was exporting from MS Access I forgot to tell it to include the field names as the first record
- The data must be tab delimited with no text qualifiers
I hope this is helpful to others. My best advice is, if you have any trouble contact the atug-l and Lee will help you out.