+ Reply to Thread
Results 1 to 3 of 3

How to convert existing Excel List into a table in Access?

Hybrid View

  1. #1
    anna
    Guest

    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. #2
    Debra Dalgleish
    Guest

    Re: 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 File>Get External Data>Import
    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. #3
    anna
    Guest

    Re: 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 File>Get External Data>Import
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1