import access db in sqlserver

  • Hi Friends..

    how to import access Data Base file in sqlserver ?

    the problem is Import access database file extension is ".accdb" in Sqlserver .

    if any one knows plz help me .

    thanks

    surya.

  • Did you try a google search? (e.g. "import accdb Data Base file in sqlserver")



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • suryagiri (4/7/2011)


    Hi Friends..

    how to import access Data Base file in sqlserver ?

    the problem is Import access database file extension is ".accdb" in Sqlserver .

    if any one knows plz help me .

    thanks

    surya.

    There is no importing an Access database in SQL Server. However, in Access you can upsize an Access database to SQL Server by going to Database Tools > SQL Server which will run the Upsize Wizard. Is this what you are trying to do?

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

  • If you are using SQL Server 2005 or 2008, I would recommend trying out Microsoft SQL Server Migration Assistant for Access.

    Download SSMA 2005 or 2008 (for your version of SQL Server) at:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b

    Read up on Migration for Microsoft Access at:

    http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

    Review Mary Chipman's Blog Post on how to use SSMA:

    http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx

  • Thanks for the links and info. I hope I never have to migrate an Access database again, but I'll definitely put SSMA into my toolbelt.

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

  • toddasd (4/13/2011)


    There is no importing an Access database in SQL Server.

    not sure what you mean by that... a data source is just a data source.

    maybe you mean the other functionalities from Access, like Forms, and not the data?

    you can import the data no problem with the new ACE drivers.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell (4/14/2011)


    toddasd (4/13/2011)


    There is no importing an Access database in SQL Server.

    not sure what you mean by that... a data source is just a data source.

    maybe you mean the other functionalities from Access, like Forms, and not the data?

    you can import the data no problem with the new ACE drivers.

    Maybe my phrasing is bad there, but what I assume suryagiri meant is "how can I take this accdb file and make it into a sql server database?" and I'm just saying there is no "import Access file" in SS.

    If I was importing data from Access, I'd probably use openrowset. I haven't heard of ACE drivers, can you link to some info?

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

Viewing 7 posts - 1 through 6 (of 6 total)

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