98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » How do I updatefrom an excel spreadsheet
How do I updatefrom an excel spreadsheet
Resolved · Low Priority · Version Standard
Frederic has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
How do I updatefrom an excel spreadsheet
How do I update a database from an excel spreadsheet without having to open the actual database.
Thank you.
Fred
RE: How do I updatefrom an excel spreadsheet
Hi Fred,
Welcome to the forum, Thank you for your post, in answer to your question, if you should have created a link between the spreadsheet which holds the variable data and the Access Database by using the File>Get External Data option in Access, and Using the Link Tables option, In the Link dialog box; change the Files of Type to Microsoft Excel, navigate to your chosen Workbook, select the Workseet to use and follow the options in the Link Wizard dialog boxes as required. When you click the final Finish button your worksheet will be imported into Access as a linked table. Any changes in your Excel Spreadsheet will be shown in your Access Database the next time it is opened.
Note: your worksheet should be created as a list with just field headings in row 1, and the data directly beneath, row 2, 3, 4 etc. I hope that has been of help to you, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |