Who can give me Microsoft access help ?
It is very easy to either import it or link so that whenever you use the spreadsheet to update in any way, it is also updated in Access. Firstly you need to open Access and create a blank database, naming it appropriately. Then, from the database window (and here I am assuming you are pre 2007 version), click on the file menu down to External Data. Here you can choose to import or link. If you import and keep the spreadsheet if you make changes in either the spreadsheet or database in the future, the other is not updated. However, if you link and want to use the spreadsheet because you might find it easier, then the tables in Access will be automatically updated. Anyhow, assuming you choose import, you next browse to where the spreadsheet is and double click on the file icon. You then see a window which lists the sheets you have in your workbook. Choose which one, then you follow the prompts to select the first row as the headings or field names, go to the next stage, I would advise no