![]() Zip code + 4 causes the zips that are only 5-digit to be preceded by a bunch of 0s, and when I link the spreadsheet to an Access database, the 0s still show and will (I assume) import that way into the table where I want to append them. ![]() ![]() I have tried formatting the zip code column in the spreadsheet as Zip code + 4, Zip code, and Text. Most zip codes are 5-digit, but a few are 9-digit with a "-" between the first 5 digits and the last 4. ![]() Have an Excel spreadsheet containing names and addresses that I have linked to an Access database. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |