SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Excel 2 Accsess

  1. #1
    SitePoint Enthusiast Nasser's Avatar
    Join Date
    Jul 2001
    Location
    Qatar
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Excel 2 Accsess

    I need to convert Excel 2000 sheet to MS Access 2000 tables? Any help

  2. #2
    There can be only One.... joelwills's Avatar
    Join Date
    Jul 2000
    Location
    England
    Posts
    201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Pretty straightforward.

    Open Access, select new database, or existing one - whatever.

    Select Insert > Table. A dialog box should open. Select Import Table. When the Browse Window opens, change the File Type to Excel, and browse to the spreadsheets location. Press Import.

    Now all you have to do is specify which worksheets you want to use, the columns you want, whether there is a header row, whether you want to create a new table or existing one, specify the field options and set a primary key and finally you're in business.

    Hope that's clear! Ask if you need any more help.
    Life Goggles - The Entertaining Environment Blog
    http://www.lifegoggles.com

  3. #3
    Captain Internet neil's Avatar
    Join Date
    Jun 2001
    Location
    n.ireland
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Along with joel's example showing how to do the conversion using access. You can also do it under excel...

    Open your Excel worksheet, click anywhere in the list, then click Convert to Access in the Data menu. The wizard will walk you through the process of converting your Excel data into Access.
    Once you have selected the option to convert from spreadsheet to database, wizard will create an entire database with its related tables, forms and reports. Twenty or so database templates are available to choose from. If you do not see a database that perfectly suits your needs, look for one that comes close and modify it to get your ideal database.

    If you don't have the Convert to Access option inside the Data menu, you'll need to install the AccessLinks add-in program. To do this, go into the Tools menu and select the Addins option and see if Microsoft Access Links Addin is listed as an option (needs to be checked).
    neil - Geocities, the trailer park of the web
    .<.<.<.<.<.<.<.<
    WEB[retype.net] + [guff.org]
    ICQ[273981] AIM[neiim]

  4. #4
    SitePoint Enthusiast Nasser's Avatar
    Join Date
    Jul 2001
    Location
    Qatar
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hay thanx joelwills,
    I will try this now .

  5. #5
    SitePoint Enthusiast Nasser's Avatar
    Join Date
    Jul 2001
    Location
    Qatar
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you too neil thanx alot .


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
  •