Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Can't Import Excel File (2002)

    Hi,

    I'm trying to import and Excel file but keep getting errors. I'm using File/Get External Data/Import and am trying to create a table based on the data. I've done everything I can think of to the sheet to get it to import but am stumped.

    Thanks,
    Leesha

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

    Re: Can't Import Excel File (2002)

    You can create a link to the Excel worksheet (File | Get External Data | Link Tables...). You can then create a select query based on the linked table, or if you prefer to have an Access table, a make-table query.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can't Import Excel File (2002)

    Thanks! I never thought of that approach!!!

    Leesha

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

    Re: Can't Import Excel File (2002)

    Your Excel file had extraneous space characters somewhere in the headings or data.

    I used the =trim() function on the two rows, copied and pasted the values into a new sheet.

    I was then able to import the file without any problem.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can't Import Excel File (2002)

    Thanks!!!

    Leesha

Posting Permissions

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