Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Import an Excel column and make it a row in access (Access 2000/xp and excel 200/xp)

    I have a column of labels in an excel file (5,000 rows). I want to import into access and use as my header (first row) fields. Is there an ez way to do this? thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    The easiest way would be to copy the range and then do a paste special in Excel and select the Transpose option. That will convert the column to a row and you can then import the range into Access without any effort. In the import, tell it the range has column headers and your labels will become field names.
    Charlotte

  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    Be aware that there is a limit of 255 fields in a table in Access 2000. I don't know whether XP is different.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    Hi,

    Bad news and good news. No, the limit still there, 255 fields per table. Good code how to transpose at MS site <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q283/8/75.ASP?LN=EN-US&SD=gn&FR=0&qry=&rnk=49&src=DHCS_MSPSS_gn_SRCH&S PR=ACC2002>http://support.microsoft.com/support/kb/ar...RCH&SPR=ACC2002</A>

    Cheers!
    Tim K.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    In addition, Excel (at least through 2000) is limited to 256 rows, so if you transpose a column with 5000 entries the wheels fall off.
    Wendell

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    I think you mean 256 columns, Wendell.
    Charlotte

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    You are so right - there I times when I suspect I have a bad case of dyslexia! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Wendell

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    What, you get your rows and columns transposed? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Import an Excel column and make it a row in access (Access 2000/xp and

    I wish that was all!!! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Wendell

Posting Permissions

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