Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: MS Access 2007 Table to SQL 2005

    Hello guys

    Please could someone help - I have a MS Access 2007 database table which I need to migrate into my existing SQL 2005 server.

    I am very desperate!

    Thanks

    Paul

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2011
    Posts
    2
    Pat - excellent advice thank you. I ran it and all seemed absolutely fine and it reported success although when I visit my site it reports an error

    HTML Code:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
    
    [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblCPCategories'.
    
    /Classifieds/XcClassified.asp, line 31
    Thank you though

Posting Permissions

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