Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Problem with import

Discussion in 'Information Technology' started by Tony Williams, Jul 28, 2006.

Tags:
  1. Tony Williams

    Tony Williams
    Expand Collapse
    Guest

    I'm trying to import data from an .xls file. The first row contains the
    headings that match the field names in the table. However I keep getting a
    message to say there has been an error and the file has not been imported.
    There is no indication what the error is though. The only thing I can see
    that is wrong is that one column on the xls spreadsheet has a date in the
    format dd/mm/yy which matches the format in the table, but when the file
    spreadsheet appears in the import wizard the date appears as a 5 digit
    number that doesn't look anything like a date. No matter what I do to the
    format it doesn't change. Could that be the problem and if so how do I
    change it?
    Thanks
    Tony
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    >>the date appears as a 5 digit number that doesn't look anything like a date.
    Access and Excel stores dates and time as a decimal number but displays them
    in several ways.
    One problem when importing from Excel to Access is that Access tries to help
    by change columns to what it thinks is correct.
    If you have a column that has text and numerials the best way to import is
    to add a new row under the headings and make sure there is text in those
    cells.

    "Tony Williams" wrote:

    > I'm trying to import data from an .xls file. The first row contains the
    > headings that match the field names in the table. However I keep getting a
    > message to say there has been an error and the file has not been imported.
    > There is no indication what the error is though. The only thing I can see
    > that is wrong is that one column on the xls spreadsheet has a date in the
    > format dd/mm/yy which matches the format in the table, but when the file
    > spreadsheet appears in the import wizard the date appears as a 5 digit
    > number that doesn't look anything like a date. No matter what I do to the
    > format it doesn't change. Could that be the problem and if so how do I
    > change it?
    > Thanks
    > Tony
    >
    >
    >
     
  4. Tony Williams

    Tony Williams
    Expand Collapse
    Guest

    Thanks Karl I'll have a look at that
    Tony
    "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
    news:B2315C10-7103-43D5-9ADF-8E1E448907D8@microsoft.com...
    >>>the date appears as a 5 digit number that doesn't look anything like a
    >>>date.

    > Access and Excel stores dates and time as a decimal number but displays
    > them
    > in several ways.
    > One problem when importing from Excel to Access is that Access tries to
    > help
    > by change columns to what it thinks is correct.
    > If you have a column that has text and numerials the best way to import is
    > to add a new row under the headings and make sure there is text in those
    > cells.
    >
    > "Tony Williams" wrote:
    >
    >> I'm trying to import data from an .xls file. The first row contains the
    >> headings that match the field names in the table. However I keep getting
    >> a
    >> message to say there has been an error and the file has not been
    >> imported.
    >> There is no indication what the error is though. The only thing I can see
    >> that is wrong is that one column on the xls spreadsheet has a date in
    >> the
    >> format dd/mm/yy which matches the format in the table, but when the file
    >> spreadsheet appears in the import wizard the date appears as a 5 digit
    >> number that doesn't look anything like a date. No matter what I do to the
    >> format it doesn't change. Could that be the problem and if so how do I
    >> change it?
    >> Thanks
    >> Tony
    >>
    >>
    >>
     

Share This Page