How to convert existing Excel List into a table in Access?
Is it possible to convert existing Excel List into a table in Access database
in 2003 Excel I know it was possible in 2002 version through AccessLinks ? |
How to convert existing Excel List into a table in Access?
You can import the Excel list into Access, and use it there as a table.
In Access, choose FileGet External DataImport In the Files of Type dropdown, at the bottom of the dialog box, choose Microsoft Excel Locate and select your Excel file, and click Import Step through the Import Wizard, to complete the import. anna wrote: Is it possible to convert existing Excel List into a table in Access database in 2003 Excel I know it was possible in 2002 version through AccessLinks ? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
How to convert existing Excel List into a table in Access?
Thanks Debra it is exacly what I m doing I just wondered about that
AccessLinks which were availible through add-in program in 2002 version "Debra Dalgleish" wrote: You can import the Excel list into Access, and use it there as a table. In Access, choose FileGet External DataImport In the Files of Type dropdown, at the bottom of the dialog box, choose Microsoft Excel Locate and select your Excel file, and click Import Step through the Import Wizard, to complete the import. anna wrote: Is it possible to convert existing Excel List into a table in Access database in 2003 Excel I know it was possible in 2002 version through AccessLinks ? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com