SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2002
    Location
    Northern Ireland
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exporting from Excel to Access

    Hi Folks

    Hope this is the right Forum for starters?
    Can anyone please give me an "Idiots Gude" on how to export data from Excell To MS Access?

    Many thanks in anticipation

    Andrew

  2. #2
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    put all the data you want to import on one worksheet, and put column names at the top.

    Open Access. Start with a new database, unless you have an existing db you wish to import to. Right click in the middle, and choose import.

    Navigate to the XLS file, click OK, and follow the wizard.

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2002
    Location
    Northern Ireland
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Many thanks Randem, much appreciated

    Cheers

    Andrew

  4. #4
    SitePoint Addict ThomasAesir's Avatar
    Join Date
    May 2002
    Location
    Sydney, Australia
    Posts
    214
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Copy and paste append

    Highlight and copy your Excel table, then go to your Access table and paste append from the Edit menu. You just have to make sure that your Access table is setup for the data your importing.
    Thomas Oeser - Blueprint Software
    Web Scripting Editor v 5.2 One cool Web editing tool.
    3dcomputergraphics.com Coming Soon!


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
  •