Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    36

    Unanswered: Can't import table from excel

    I have created an xls and its the same format as the table in my db. Same column name and same data type. However, when I try to import the xls to an existing table in my db, there was an error message that says, "An error occurred while trying to import file 'C:\MyDocuments\POSystem_Book.xls'. The file was not imported'". This error does not occur when I import it to a new table. Can anyone help in this? A million thanks in advance.

    Regards,
    Swee

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Then imopt it to a new table, then compare the fileds of the new table with that of the other one, compare the field types, names and length....

  3. #3
    Join Date
    Aug 2004
    Posts
    36
    All the fields have the same file types and I have checked whatever I think could be the problem but still no progress. Could you help me take a look at it? I have uploaded my xls and my sample db.
    Attached Files Attached Files

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Now you can import from Excel to your table, not you decided for your key to be without doopplication. So don't try to imoprt records with the same key...
    Attached Files Attached Files

  5. #5
    Join Date
    Aug 2004
    Posts
    36
    Its the length of the fields. Got it sorted out after making them the same. Thanks for the help!

Posting Permissions

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