Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Word address list to Excel | Excel Discussion (Misc queries) | |||
Data from Excel to Access Table | Excel Discussion (Misc queries) | |||
data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
vlookup function in excel referencing an access table | Excel Worksheet Functions |