Blog Archives

Add Sequence Number to a Table

There are times you want each record to have a unique identifier.  This function will add a unique sequence number to each record in any table.  It assumes you have a field in the target table that will store the sequence numbers. … Continue reading

Aside | Posted on by | Tagged , | 1 Comment

Importing Excel into Access. Sometimes Access is too smart for its own good.

Ever try to import an Excel file into Access and find that some records were not imported because they didn’t match the field type (text, integer)?  Access tries to predict the field type based on the data it sees and … Continue reading

Aside | Posted on by | Tagged , | Leave a comment