Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Who can give me Microsoft access help ?

0
Posted

Who can give me Microsoft access help ?

0

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

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123