• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3615
  • Last Modified:

How to import Access 2007 Database into SQL Server 2008

I downloaded the 180 days free trial of SQL server 2008 from the following website:

http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

I followed the on-line instruction in installing the free trial of server 2008 on my PC. I have created an Asset Management Database in access 2007. Can you please provide a step by step guide in how to import MA Access 2007 into SQL 2008.

Thanks
0
citytemp1
Asked:
citytemp1
  • 4
  • 4
1 Solution
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
You can use the Import/ Export Wizard to achieve it:

1. Right Click Your database in SSMS
2. Choose Tasks --> Import Data
3. Choose the Source as Access and select the list of tables.
4. Associate it with Destination tables in SQL Server.

You are done.
0
 
citytemp1Author Commented:
I have tried doing the above but I receive an error alert.

Please view the screen shot and advice how to overcome the error

Thanks
An-alert-received.bmp
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Open Access 2007 database and save it in Access 2000 or 2003 format (*.mdb).

Now try to do the same approach as you followed now and you would be able to load it now.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
citytemp1Author Commented:
Yes, I have already tried that I get the following message in stead

view screen shot

what else can you suggest
save-to-another-vers..bmp
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Can you check this once more for converting steps:

http://office.microsoft.com/en-us/access/HA102308221033.aspx?pid=CH100645711033

If that is not possible, then try the option of creating that *.accdb as a linked server to sql server.
Once it is created, you can directly query that access from SQL Server and insert it into whatever table we require.
0
 
citytemp1Author Commented:
That's how i tried to do the DB conversion in the first place, still no joy

How would I go about linking the DB to sql.

do you have a step by step instruction on the process?
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
0
 
citytemp1Author Commented:
Cheers, I'll try that and see how it goes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now