Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IMPORTING EXCEL SPREADSHEETS (OFFICE 2000)

    When trying to import an Excel spreadsheet into Access the last 5 columns of a 20 column spreadsheet will not transfer. However if I attempt to import the last 5 columns alone, the last 5 columns will appear. If I attempt to import the last 6 columns, only the first column will show up. Has anyone had this problem ?
    Paul B

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IMPORTING EXCEL SPREADSHEETS (OFFICE 2000)

    Just a guess - are there any hiddencolumns in the xls?

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IMPORTING EXCEL SPREADSHEETS (OFFICE 2000)

    I've experienced importing problems if (1) the column heading in Excel is not a valid Access field name or (2) the column headings in Excel are duplicates.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IMPORTING EXCEL SPREADSHEETS (OFFICE 2000)

    I could have sworn I sent you a reply but I can't seem to find it. You were right --A hidden column was the problem.

Posting Permissions

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