import access db in sqlserver

Question

Post reply

import access db in sqlserver

suryagiri

SSC Journeyman

Points: 79
More actions
April 7, 2011 at 11:57 pm

#238161

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.

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

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

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]

toddasd SSCertifiable Points: 6298 More actions · Answer 2

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.

Zim SSC Enthusiast Points: 131 More actions · Answer 3

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

toddasd SSCertifiable Points: 6298 More actions · Answer 4

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.

Lowell SSC Guru Points: 323518 More actions · Answer 5

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!

toddasd SSCertifiable Points: 6298 More actions · Answer 6

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.