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. 🙂


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

  • RSS Disturb the universe?

  • Pages

  • March 2007
    M T W T F S S
    « Feb   Apr »
  • Meta

  • %d bloggers like this: