Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pulling lots of data into Excel (2003)

    Not sure how I can do this; I have a list of 300 assets. We have an Access Database we create of all our assets. I am experimenting with Microsoft Query to see if I can extract the data fields for those 300 assets into an Excel ss for further work. In Access, I don't think I can build a query with that many items in it, correct? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pulling lots of data into Excel (2003)

    I'm not sure what exactly you mean. A query in Access cannot have more than 255 columns, but an Excel worksheet has exactly 256 columns, no more (until Excel 2007 arrives). So transferring the data from Access to Excel will not allow you to work with 300 columns either. Neither Access nor Excel have problems with 300 rows (records).

Posting Permissions

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