Print labels using Access

How do I print funky little labels for MSB Mammal specimens?

Sign in to Arctos and search for specimens in the usual way. Select Label Data Download in the Manage menu and click Go.

Right-click and save the resulting CSV file. The name and location of this file will be important later. Put it somewhere convenient, and accept the default name.

Download the MSB_Labels.mdb Access template from the Arctos Group Files site.

From the Access Tables tab in the file you just downloaded, click New at the top.

Choose Link Table in the resulting popup and click OK.

Change Files of type to "Text." Find and select the file you just downloaded from Arctos. It should be named ArctosLabelData.csv.
Click Link.

Select Delimited in the resulting window, then click Next.

Change Text Qualifier to quote ( " ). Do this first or you'll get scary but harmless Microsoft errors.

Pick Comma as delimiter.

Check First Row Contains Field Names.

Click Finish.

From the main menu, click Reports. msbLabelReport (the only report currently in the DB) will contain labels for the file you downloaded from Arctos.

To print another group of labels, simply close Access (to prevent lock conflicts), search Arctos, and download the CSV as before. You should be prompted to over-write the existing CSV file. The new data will then automatically be available from the Access report.

If you wish to change anything with the MDB file, you can either request that I make the changes or make them yourself, but make sure to send me the updated version. I'll keep that on the download site so it's always available. I can change the data download as needed.

This is not intended to be a permanent solution. We'll find something better someday.

No comments: