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 » Export
Export
Resolved · Low Priority · Version Standard
RE: export
Hi Faith, Thank you for the post, In answer to your question to import a table from Excel; Choose the menu command File>Get External Data>Import, From the dialog box, change the Files of Type to Excel and navigate to find the workbook of your choice, follow the steps in the wizard to choose the sheet to import. Ensure that the sheet follows the rules of database creation ie field name column headers, no gaps between header and data etc. I hope that helps, 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:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |