Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    65

    Unanswered: Type conversion Failure when importing from Excel

    Hi,
    I am using Office 2000, when importing data from an excel spreadsheet into a new table in Access it does not import certain records. Instead it will create a table where references are given to the rows/cells that were not converted. one such example includes numerical data. I have checked the data on the spreadsheet and its in numerical format but when i import and check the table in Access the records are blank. Can anyone advise why this is happening? and how to fix

    many thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    12'345,67
    12.234,67
    12,345.67
    12'345.67
    1.234567E+04
    are all in "numerical format".

    experiment:
    in Excel, save the data as .CSV
    examine the .CSV
    if nothing "strange" in the .CSV try importing the .CSV ...did it work ???
    if not, hit the Specs... button in the import dialog and see if you can tweak the .CSV import to make it work.

    i don't trust XLS import - i don't get enough control and Mr Gates makes too many assumptions based on the first few rows of the XLS.
    one of my recurrent nightmares with XLS-import is with product groups 12, 13, 14, G4, H5, H6 ...Mr Gates sees the first few (numeric) rows and guesses (incorrectly) that the column is numeric, dropping the rest of my import.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Apr 2006
    Posts
    65
    good advice, many thanks

    will try that and report back!

Posting Permissions

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