Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Import from XL - IImexGrid object error (2003)

    I am trying to import a simple and small excel table (three columns: date, and two numeric values, ~150 rows) into an Access database to update a table (the Excel file represents new data and should be appended to the Access table). I have done this before - in fact, it was how the Access table was created, although with an early version of the Excel file with much more data (~2000 records).

    When I click on File | Get External Data > Import and specify an Excel file (in XL 2003 format) and the file I want, I get an error message I have never seen:
    <hr>Method 'Columns' of object IImexGrid' failed<hr>

    If I click on "Okay" (the only choice), the spreadsheet import wizard seems to continue normally, and I can specify that the file should be imported to an existing table but the actual import fails, and I get a message that an error occurred in the import and the file was not imported. Has anyone run into this error, or have any idea what to do about it?

    UPDATE
    I just trried with a little (10 records) Excel file of fake data, and it was imported without problem. My data comes from a data-extraction tool run in another department, so there may be something odd about the excel file that they deliver it in, although there is nothing obviously different about it. If so, in the past I may have manipulated the data or cut / pasted it into a new file rather than trying to save and import from the original file. If worse comes to worst, I will be able to manualy re-create 150 records in a new XL file, but any insight will still be appreciated.

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

    Re: Import from XL - IImexGrid object error (2003)

    Make sure that the worksheet doesn't have data or formatting outside the table that you want to import. If you want to import only part of the sheet, define a named range (Insert | Name | Define) in Excel, and specify this name when you import into Access.

    If the first row of the worksheet (or range) contains field names, make sure that ALL columns within the table range have valid field names.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Import from XL - IImexGrid object error (2003)

    Thanks Hans

    I ended up cut/pasting the required data into a new s/sheet and it imported fine. There may have been formatting or blanks entered as " " outside the data range, but I'd have to go back and look. The data actually comes in two files (dates and prices for two different markets), and I want both prices to form part of a record for the same date, so it's easiest to cut & paste in Excel, rather than importing as two tables and assembling the data through a query. If I'm going to be cut/pasting in Excel anyway, it's just as easy to paste into a new file that I know is clean.

Posting Permissions

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