help help help please
Hi All I need to know how to import excel spreadsheets onto access. My manual only covers how to create access databases but at work we will be receiving information on excel spreadsheets that needs to be imported onto an acess database. Not sure how this is done Can anyone please help ?? Cheers Paul |
In Access: File Get External Data Import (then) Change "Files of type"
to Microsoft Excel (*.xls), browse to your Excel file, click on Import, then follow the Wizard's instructions. BTW, this is an Excel group :-) -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "news.cable.ntlworld.com" wrote in message ... Hi All I need to know how to import excel spreadsheets onto access. My manual only covers how to create access databases but at work we will be receiving information on excel spreadsheets that needs to be imported onto an acess database. Not sure how this is done Can anyone please help ?? Cheers Paul |
All times are GMT +1. The time now is 11:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com