another MSSql to Access question

Posted on 2011-10-04
Last Modified: 2012-05-12
I have an old backup file from an MSSQL 2003 server.  The file was created with the "Backup Database"

Can I somehow import that into a access 2007 database?
Question by:TIgerV
    LVL 25

    Accepted Solution

    The backup file would need to be restored to SQL Server. You would need to know the correct version (there is no SQL 2003) as you can only restore to a SQL Server of equal or high version. From there, you could connect to the back from Access and import the data.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    sql 2003 would be Small Business Server, which contains a special sql server version.

    apart from that, you can restore such a backup only into another sql server (same or higher version), and link from there from ms access .

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now