Category Archives: Access Tips

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

Lost those leading zeros in Excel / Access?

You’ve imported data into your Excel sheet or Access application and those important leading zeros got lost.  For example, your 5 digit zip code (04231) is now only 4 digits (4231). Here’s a simple formula to get back the zeros: … Continue reading

Posted in Access Tips, Excel Tips | Leave a comment