Welcome to SPN

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

Sign Up Now!

Migration tool Access 2003->2000/SQL Express

Discussion in 'Information Technology' started by msch-prv@bluewin.ch, Jul 28, 2006.

  1. msch-prv@bluewin.ch

    msch-prv@bluewin.ch
    Expand Collapse
    Guest

    This is a trivial question but most posts I have looked up always
    assume that a working copy of Access 2003 is available, which is not my
    case. (I use Office 2K and don't plan to upgrade.)

    I would like to convert a 2003 database down to A2K. The db acts as BE
    and contains only tables; so the conversion should be straightforward.

    Is there a tool out there that does that sort of conversion? I tried
    stpworks at http://www.stpworks.com for exporting data in .csv but it
    isn't working correctly.

    If no such tool is available, would it be possible to migrate the 2003
    db to SQL Express? If yes, how? My understanding is that this can only
    be done natively ie. you need Access 2003 to either convert back to A2k
    or upwards to MS SQL/SQL Express.

    Thanks for any suggestions, Mark
     
  2. Loading...

    Similar Threads Forum Date
    Reincarnation / Transmigration: Revisited & Re-explored Intellectual Articles Apr 9, 2015
    Canada Racist Anti-immigration flyers single out Sikh community in Brampton Breaking News Apr 25, 2014
    Canada MP pleads with immigration minister not to deport elderly sikh woman Breaking News Dec 12, 2012
    Canada Canada Immigration Reform: Jason Kenney Seeks Young, Educated, Skilled And Fluent Newcomers Breaking News Oct 31, 2011
    Opinion Distress pushing migration in India Punjab, Punjabi, Punjabiyat Oct 1, 2011

  3. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    A wild guess that I say without any thinking: did you try creating an empty
    MDB file and linking or importing all the tables from the old one using ODBC
    linked tables?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    <msch-prv@bluewin.ch> wrote in message
    news:1152981373.808619.213800@s13g2000cwa.googlegroups.com...
    > This is a trivial question but most posts I have looked up always
    > assume that a working copy of Access 2003 is available, which is not my
    > case. (I use Office 2K and don't plan to upgrade.)
    >
    > I would like to convert a 2003 database down to A2K. The db acts as BE
    > and contains only tables; so the conversion should be straightforward.
    >
    > Is there a tool out there that does that sort of conversion? I tried
    > stpworks at http://www.stpworks.com for exporting data in .csv but it
    > isn't working correctly.
    >
    > If no such tool is available, would it be possible to migrate the 2003
    > db to SQL Express? If yes, how? My understanding is that this can only
    > be done natively ie. you need Access 2003 to either convert back to A2k
    > or upwards to MS SQL/SQL Express.
    >
    > Thanks for any suggestions, Mark
    >
     
  4. msch-prv@bluewin.ch

    msch-prv@bluewin.ch
    Expand Collapse
    Guest

    Sylvain, thanks for the suggestion.

    I finally created an ASP script that uses an OBDC connection to pull
    out data from each table and load it in a text file. Each text file is
    then formatted in Excel and imported back into A2K. What a nightmare!

    Why doesn't MS make such tools available?

    Regards, Mark
     
  5. msch-prv@bluewin.ch

    msch-prv@bluewin.ch
    Expand Collapse
    Guest

    Sylvain, thanks for the suggestion.

    I finally created an ASP script that uses an OBDC connection to pull
    out data from each table and load it in a text file. Each text file is
    then formatted in Excel and imported back into A2K. What a nightmare!

    Why doesn't MS make such tools available?

    Regards, Mark
     
  6. msch-prv@bluewin.ch

    msch-prv@bluewin.ch
    Expand Collapse
    Guest

    Well, this is confusing. Are we talking about importing A2003 mdbs into
    SQL Express or A2K?

    As far as I know (and re-tested), you cannot import a 2003 table into
    A2K. A2K flags you with an error message.

    If you refer to SQL Express, then I don't know of a way to import mdb.
    The ASP2.0 starter kit I'm using enables you to create tables manually.
    Is there a separate mdb/SQL Express import utility?

    Mark
     
  7. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On 16 Jul 2006 09:46:54 -0700, msch-prv@bluewin.ch wrote:

    >Well, this is confusing. Are we talking about importing A2003 mdbs into
    >SQL Express or A2K?


    I think you'll find that dbahooker is more than a bit fanatical about
    this subject. He never posts here other than to bash Jet databases and
    all of us who are successfully using them; I'd review some of his
    previous posts using groups.google.com before taking his advice to
    heart.


    John W. Vinson[MVP]
     
  8. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Well, I don't have a copy of Access 2000 at hand so I'm not sure of the
    following; however, if you can pull your data from ASP then you should be
    able to do exactly the same with VBA code and ADO objects directly from
    inside your Access file.

    Also, I don't understand why you don't try to create linked tables to
    directly get access to the data. (Or use the syntaxe IN ). Linked tables
    are based on ODBC, so you shouldn't have any problem to link tables between
    the A2000 and A2003 formats.

    They are many ways and tools to transfert data; however, I think that you
    mention of SQL-Express as a way of downgrading the format of the MDB
    database from A2003 to A2000 is confusing everyone here on what exactly you
    want to do.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    <msch-prv@bluewin.ch> wrote in message
    news:1153062534.537828.128370@p79g2000cwp.googlegroups.com...
    > Sylvain, thanks for the suggestion.
    >
    > I finally created an ASP script that uses an OBDC connection to pull
    > out data from each table and load it in a text file. Each text file is
    > then formatted in Excel and imported back into A2K. What a nightmare!
    >
    > Why doesn't MS make such tools available?
    >
    > Regards, Mark
    >
     
  9. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    I've just checked on MSDN and Access 2000 or Office 2000 are no longer
    available; so I cannot install them to make a quick check.

    If you are not really interested in copying your data to SQL-Express and
    that you still have trouble with ODBC linked tables or with calling ADO
    objects from VBA inside Access, I would suggest that you make a repost but
    without any mention of SQL-Express.

    MS is making some tools, like DTS (for SQL-Server 2000) or SSIS (for
    SQL-Server 2005/Express); however it would be far more easier for you to
    stick with ODBC linked tables or ADO objects.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    wrote in message news:utALZTVqGHA.4812@TK2MSFTNGP04.phx.gbl...
    > Well, I don't have a copy of Access 2000 at hand so I'm not sure of the
    > following; however, if you can pull your data from ASP then you should be
    > able to do exactly the same with VBA code and ADO objects directly from
    > inside your Access file.
    >
    > Also, I don't understand why you don't try to create linked tables to
    > directly get access to the data. (Or use the syntaxe IN ). Linked tables
    > are based on ODBC, so you shouldn't have any problem to link tables
    > between the A2000 and A2003 formats.
    >
    > They are many ways and tools to transfert data; however, I think that you
    > mention of SQL-Express as a way of downgrading the format of the MDB
    > database from A2003 to A2000 is confusing everyone here on what exactly
    > you want to do.
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Technologies Virtual-PC
    > E-mail: http://cerbermail.com/?QugbLEWINF
    >
    >
    > <msch-prv@bluewin.ch> wrote in message
    > news:1153062534.537828.128370@p79g2000cwp.googlegroups.com...
    >> Sylvain, thanks for the suggestion.
    >>
    >> I finally created an ASP script that uses an OBDC connection to pull
    >> out data from each table and load it in a text file. Each text file is
    >> then formatted in Excel and imported back into A2K. What a nightmare!
    >>
    >> Why doesn't MS make such tools available?
    >>
    >> Regards, Mark
    >>

    >
    >
     
  10. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    One final thought: as you don't have Access 2003 installed, then maybe
    installing the latest version of MDAC and after that the latest of the JET
    drivers could help you:

    http://msdn.microsoft.com/data/ref/mdac/downloads/

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    wrote in message news:OYuHfdVqGHA.4760@TK2MSFTNGP03.phx.gbl...
    > I've just checked on MSDN and Access 2000 or Office 2000 are no longer
    > available; so I cannot install them to make a quick check.
    >
    > If you are not really interested in copying your data to SQL-Express and
    > that you still have trouble with ODBC linked tables or with calling ADO
    > objects from VBA inside Access, I would suggest that you make a repost but
    > without any mention of SQL-Express.
    >
    > MS is making some tools, like DTS (for SQL-Server 2000) or SSIS (for
    > SQL-Server 2005/Express); however it would be far more easier for you to
    > stick with ODBC linked tables or ADO objects.
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Technologies Virtual-PC
    > E-mail: http://cerbermail.com/?QugbLEWINF
    >
    >
    > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    > wrote in message news:utALZTVqGHA.4812@TK2MSFTNGP04.phx.gbl...
    >> Well, I don't have a copy of Access 2000 at hand so I'm not sure of the
    >> following; however, if you can pull your data from ASP then you should be
    >> able to do exactly the same with VBA code and ADO objects directly from
    >> inside your Access file.
    >>
    >> Also, I don't understand why you don't try to create linked tables to
    >> directly get access to the data. (Or use the syntaxe IN ). Linked tables
    >> are based on ODBC, so you shouldn't have any problem to link tables
    >> between the A2000 and A2003 formats.
    >>
    >> They are many ways and tools to transfert data; however, I think that you
    >> mention of SQL-Express as a way of downgrading the format of the MDB
    >> database from A2003 to A2000 is confusing everyone here on what exactly
    >> you want to do.
    >>
    >> --
    >> Sylvain Lafontaine, ing.
    >> MVP - Technologies Virtual-PC
    >> E-mail: http://cerbermail.com/?QugbLEWINF
    >>
    >>
    >> <msch-prv@bluewin.ch> wrote in message
    >> news:1153062534.537828.128370@p79g2000cwp.googlegroups.com...
    >>> Sylvain, thanks for the suggestion.
    >>>
    >>> I finally created an ASP script that uses an OBDC connection to pull
    >>> out data from each table and load it in a text file. Each text file is
    >>> then formatted in Excel and imported back into A2K. What a nightmare!
    >>>
    >>> Why doesn't MS make such tools available?
    >>>
    >>> Regards, Mark
    >>>

    >>
    >>

    >
    >
     

Share This Page