B
Bart
Open your Access program, hit F11, click on the table tab,
click on new and select import table, change your file
type to excel, find the spreadsheet you want to import and
follow the spreadsheet wizard. Good luck.
this to my MS Access database so that when I enter a city,
the state, zipcode and county will automatically populate
so I don't have to type them in each time? For example,
whenever I put in city "Harwich", it would auto populate
the fields for state with "MA", zipcode field
with "02645", and county "Barnstable".
click on new and select import table, change your file
type to excel, find the spreadsheet you want to import and
follow the spreadsheet wizard. Good luck.
zipcodes, towns, and counties. Is there anyway to import
this to my MS Access database so that when I enter a city,
the state, zipcode and county will automatically populate
so I don't have to type them in each time? For example,
whenever I put in city "Harwich", it would auto populate
the fields for state with "MA", zipcode field
with "02645", and county "Barnstable".