SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jun 2004
    Location
    singapore
    Posts
    29
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    can excels 2002 file can be convert to access 2002 ?

    as mentioned above. can it excels file can be converted to access 2002 file?

    sorry as i am newbie and dun know much about access2002 well. i am still figuring out how to create the data entry and how it really works.

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,625
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    If the excel file is formatted like a table (in distinct columns, solid set of rows, no wierd notes and especially no merged cells) then yes, one can import it into an access table. Just do file->get external data->Import and follow the wizard.

    WWB


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
  •