Welcome to SPN

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

Sign Up Now!

Upsizing wizard

Discussion in 'Information Technology' started by Dick Bosworth, Jul 28, 2006.

  1. Dick Bosworth

    Dick Bosworth
    Expand Collapse
    Guest

    I'm trying to use the upsizing wizard to import data to sql Server Express.
    All of my tables are not imported, and the following error message shows up
    on the report. "tbl skipped or export error"

    Anyone know what might be wrong?
     
  2. Loading...

    Similar Threads Forum Date
    The wonderful wizard of Sachkhand Blogs Oct 17, 2015

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote:

    >I'm trying to use the upsizing wizard to import data to sql Server Express.
    >All of my tables are not imported, and the following error message shows up
    >on the report. "tbl skipped or export error"


    Chances are there are a few records with dates accidentally entered
    with the century before 1800 or after 2100. SQL Server's default date
    format lies somewhere in those boundaries and the Upsizing wizard
    doesn't handle those properly.

    There is a new tool from the SQL Server group.
    SQL Server Migration Assistant for Access (SSMA Access)
    http://www.microsoft.com/sql/solutions/migration/default.mspx

    This tool may do a better job of handling this problem.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  4. Dick Bosworth

    Dick Bosworth
    Expand Collapse
    Guest

    I'll have a look at my records.

    Many thanks

    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:6abab2dko1n15n5vtbb2fpmk0gb2h3pj5a@4ax.com...
    > "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote:
    >
    >>I'm trying to use the upsizing wizard to import data to sql Server
    >>Express.
    >>All of my tables are not imported, and the following error message shows
    >>up
    >>on the report. "tbl skipped or export error"

    >
    > Chances are there are a few records with dates accidentally entered
    > with the century before 1800 or after 2100. SQL Server's default date
    > format lies somewhere in those boundaries and the Upsizing wizard
    > doesn't handle those properly.
    >
    > There is a new tool from the SQL Server group.
    > SQL Server Migration Assistant for Access (SSMA Access)
    > http://www.microsoft.com/sql/solutions/migration/default.mspx
    >
    > This tool may do a better job of handling this problem.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
     
  5. Dick Bosworth

    Dick Bosworth
    Expand Collapse
    Guest

    I checked the dates, and they are all valid. Any other suggestions. Your
    link wants me to purchase SQL Server. I'm using the free express addition.

    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:6abab2dko1n15n5vtbb2fpmk0gb2h3pj5a@4ax.com...
    > "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote:
    >
    >>I'm trying to use the upsizing wizard to import data to sql Server
    >>Express.
    >>All of my tables are not imported, and the following error message shows
    >>up
    >>on the report. "tbl skipped or export error"

    >
    > Chances are there are a few records with dates accidentally entered
    > with the century before 1800 or after 2100. SQL Server's default date
    > format lies somewhere in those boundaries and the Upsizing wizard
    > doesn't handle those properly.
    >
    > There is a new tool from the SQL Server group.
    > SQL Server Migration Assistant for Access (SSMA Access)
    > http://www.microsoft.com/sql/solutions/migration/default.mspx
    >
    > This tool may do a better job of handling this problem.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
     
  6. Dick Bosworth

    Dick Bosworth
    Expand Collapse
    Guest

    OOPS I didn't read your response in its entirety. I just downloaded the
    migration assistant.
    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:6abab2dko1n15n5vtbb2fpmk0gb2h3pj5a@4ax.com...
    > "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote:
    >
    >>I'm trying to use the upsizing wizard to import data to sql Server
    >>Express.
    >>All of my tables are not imported, and the following error message shows
    >>up
    >>on the report. "tbl skipped or export error"

    >
    > Chances are there are a few records with dates accidentally entered
    > with the century before 1800 or after 2100. SQL Server's default date
    > format lies somewhere in those boundaries and the Upsizing wizard
    > doesn't handle those properly.
    >
    > There is a new tool from the SQL Server group.
    > SQL Server Migration Assistant for Access (SSMA Access)
    > http://www.microsoft.com/sql/solutions/migration/default.mspx
    >
    > This tool may do a better job of handling this problem.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
     
  7. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    Other possibilities:

    - some field's default value property is set to a function, or something
    that the wizard can't find the equivalent.
    - the table is hidden


    --
    Joan Wild
    Microsoft Access MVP

    {censored word, do not repeat.} Bosworth wrote:
    > I checked the dates, and they are all valid. Any other suggestions.
    > Your link wants me to purchase SQL Server. I'm using the free express
    > addition.
    > "Tony Toews" <ttoews@telusplanet.net> wrote in message
    > news:6abab2dko1n15n5vtbb2fpmk0gb2h3pj5a@4ax.com...
    >> "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote:
    >>
    >>> I'm trying to use the upsizing wizard to import data to sql Server
    >>> Express.
    >>> All of my tables are not imported, and the following error message
    >>> shows up
    >>> on the report. "tbl skipped or export error"

    >>
    >> Chances are there are a few records with dates accidentally entered
    >> with the century before 1800 or after 2100. SQL Server's default
    >> date format lies somewhere in those boundaries and the Upsizing
    >> wizard doesn't handle those properly.
    >>
    >> There is a new tool from the SQL Server group.
    >> SQL Server Migration Assistant for Access (SSMA Access)
    >> http://www.microsoft.com/sql/solutions/migration/default.mspx
    >>
    >> This tool may do a better job of handling this problem.
    >>
    >> Tony
    >> --
    >> Tony Toews, Microsoft Access MVP
    >> Please respond only in the newsgroups so that others can
    >> read the entire thread of messages.
    >> Microsoft Access Links, Hints, Tips & Accounting Systems at
    >> http://www.granite.ab.ca/accsmstr.htm
     
  8. Gil Lapid Shafriri

    Gil Lapid Shafriri
    Expand Collapse
    Guest

    You may want to try SSMA Access that should be abbeter tool the the office
    upsizing wizard.

    http://www.microsoft.com/sql/solutions/migration/default.mspx


    It fixes all kind of problems with the office upsizing wizard. One of them
    is date values out of SQL Server range.

    Gil

    "{censored word, do not repeat.} Bosworth" <{censored word, do not repeat.}(nospam)@gyrocova.com> wrote in message
    news:QIUsg.1663$Gv.549@fed1read09...
    > I'm trying to use the upsizing wizard to import data to sql Server
    > Express. All of my tables are not imported, and the following error
    > message shows up on the report. "tbl skipped or export error"
    >
    > Anyone know what might be wrong?
    >
     

Share This Page