Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I search a way to export an access 2003 database to sql server express 2008.

  • the export is on la (other computer than the server).
  • the computer have office 2003.
  • the computer doesn't have admin right (cant install things who needs admin)

access sql migration said that he cant(because 2008 is too new)

whats the better(easyer and shortway) to export the db?

share|improve this question
    
I try SSMA but theres somes thing he need to install/change with admin right, I try to ignore, but the program not start, do error, nothing. –  forX Nov 29 '11 at 20:42
    
How big is the database? How many objects? –  JNK Nov 29 '11 at 20:45
    
4small table, 1 with 4000rows, 1 with 250000rows (­~12col) –  forX Nov 29 '11 at 21:51
    
If that's it then why can't you just export to a flat file and load from that? –  JNK Nov 29 '11 at 21:52
    
its more the How load it? from my desktop –  forX Nov 29 '11 at 21:59
show 9 more comments

1 Answer

You can use the Import/Export wizard with SQL Server. I came across a very good write-up (nice pretty pictures) here on it.

share|improve this answer
    
you need to be on the server, I cant do that –  forX Nov 29 '11 at 20:43
    
No you don't. I have done it with Excel with no issue. SQL Server server and my desktop within the same network but I was not on the server. Excel file (source) was on my desktop. –  Shawn Melton Nov 29 '11 at 20:45
    
how did you get Import and Export Data on your desktop? need to install with admin right. cant do that –  forX Nov 29 '11 at 20:53
    
Ah, yeah you will have to be on a computer that has SQL Server Management Studio installed. –  Shawn Melton Nov 29 '11 at 21:35
    
I cant do that! –  forX Nov 29 '11 at 22:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.