Error importing Excel data into Access...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • puremetal33@gmail.com
    #1

    Error importing Excel data into Access...

    I have worked very little with Access and have hit a snag.

    My task right now is to import the data from a spreadsheet into an
    existing table in an Access database. I edited the .xls file so that
    fields are laid out the same L-R and made certain that the data is the
    same in both the .xls file and the table it is to be imported to have
    the same data type in each field.

    I follow the File>Get External Data>Import path and choose the .xls
    file I want to import, select the correct worksheet, check the box to
    make sure the first row is read as column headings, select the
    existing table it is to be imported to, and get an error message each
    time:

    'An error occured while trying to import the file: "(file name)". File
    could nto be imported'.

    I've also tried importing it into a new table, which works; but when I
    try to import the data from the new table into the existing table I
    get the same error.

    This .xls file has some 3000 rows in it and each needs to be a record
    in this table. Is there any way short of manually keying in the data
    that I can make it work. I'm certain there must be a way and my
    limited knowledge of Access is preventing me from finding it.

    Many Thanks,
    Jeremy

    Tags: None
    • puremetal33@gmail.com
      #2
      Re: Error importing Excel data into Access...

      On Feb 6, 12:47 pm, "puremeta...@gm ail.com" <puremeta...@gm ail.com>
      wrote:
      I have worked very little with Access and have hit a snag.
      >
      My task right now is to import the data from a spreadsheet into an
      existing table in an Access database. I edited the .xls file so that
      fields are laid out the same L-R and made certain that the data is the
      same in both the .xls file and the table it is to be imported to have
      the same data type in each field.
      >
      I follow the File>Get External Data>Import path and choose the .xls
      file I want to import, select the correct worksheet, check the box to
      make sure the first row is read as column headings, select the
      existing table it is to be imported to, and get an error message each
      time:
      >
      'An error occured while trying to import the file: "(file name)". File
      could nto be imported'.
      >
      I've also tried importing it into a new table, which works; but when I
      try to import the data from the new table into the existing table I
      get the same error.
      >
      This .xls file has some 3000 rows in it and each needs to be a record
      in this table. Is there any way short of manually keying in the data
      that I can make it work. I'm certain there must be a way and my
      limited knowledge of Access is preventing me from finding it.
      >
      Many Thanks,
      Jeremy
      One other thing, I attempted to save the .xls file in both .csv
      and .txt format and got the same result - the import error. Comma
      delimited came closest to working, but it didn't like the field names
      in the .csv file and errored out as a result.

        Comment

        Previous template Next
        Working...