• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3593
  • 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 & ArchitectCommented:
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 & ArchitectCommented:
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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 & ArchitectCommented:
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 & ArchitectCommented:
0
 
citytemp1Author Commented:
Cheers, I'll try that and see how it goes
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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