Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lenovo27
Starting Member
15 Posts |
 Posted - 2009-11-18 : 16:35:28
|
| I have to get data out of an old access db, but SQL Express doesn't seem to allow me to attach Access db files? Either I need a different version or I am trying to attach Access wrong? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-18 : 17:27:30
|
| Can't attach. IF you have SQL Express with Advanced services you can SSIS the data into SQL Server.If not, export the data to text files and Bulk Insert 'em into SQL |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-19 : 05:19:23
|
| Isn't there an Access-SQL conversion wizard somewhere on the Microsoft site?--Gail ShawSQL Server MVP |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-19 : 11:32:03
|
quote:
Originally posted by lenovo27
I have to get data out of an old access db, but SQL Express doesn't seem to allow me to attach Access db files? Either I need a different version or I am trying to attach Access wrong?
Just to make this clear, you can't attach an Access database to any version or edition of SQL Server. It has nothing to do with it being Express. Access format is not compatible with SQL Server files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
lenovo27
Starting Member
15 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-19 : 19:14:43
|
Great, glad to hear it!  Be sure to come back often with any other issues you may have! |
|
|
|
|
|
|
Can I attach an Access DB to SQL Server Express?