Post reply

DTS connection for Access 2007

  • May 26, 2008 at 11:22 am

    #125513

    Does anyone know of a way to update the connection options for a DTS package in SQL 2000 so that I can import data from an Access 2007 database?

    I am trying to update our database to the new format but the application is dependant on the DTS package working. Currently there is no option for 2007 db's.

    If you don't stand for something, you'll fall for anything!,

    Don Urquhart

  • May 27, 2008 at 8:26 pm

    #820930

    Here is a link. May it help.

    http://www.easyfrom.net/articles/ms_access_to_sql_server/

    But I would like to recommend you to export data to Access 2005, then import to Access 2007.

  • May 28, 2008 at 7:09 am

    #821151

    SQL ORACLE (5/27/2008)

    Here is a link. May it help.

    http://www.easyfrom.net/articles/ms_access_to_sql_server/

    But I would like to recommend you to export data to Access 2005, then import to Access 2007.

    Unfortunately, this is not a one time conversion.

    We have an Access front end for an application the imports & manipulates data before it is uploaded to the SQL DB. What I need to know is if there is a way to update the DTS connection type to include the .accdb type used in Access 2007.

    If you don't stand for something, you'll fall for anything!,

    Don Urquhart

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply