Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
3
I have an MS SQL database that I need to convert to Access, or export to Excel (which I can later import into Access). There seem to be lots of options.
Does anyone here recommend one over the others?
Thanks
4 replies to this topic
Back to top|
|
|
#2
Posted 25 January 2012 - 08:14 PM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
- Location:Upstate, South Carolina
- Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
- Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Why do you want to do this? Depending on the size of your database, moving it to Access is just begging for problems.
#3
Posted 26 January 2012 - 09:17 AM
lespauled
-
- Members
-
- 231 posts
Programming Professional
- Programming Language:C, C++, C#, JavaScript, PL/SQL, Delphi/Object Pascal, Visual Basic .NET, Pascal, Transact-SQL, Bash
My thoughts exactly. My recommendation: stay in SQL Server.
#4
Posted 27 January 2012 - 12:37 PM
Orjan
-
- Moderators
-
- 3,298 posts
Writes binary right handed and hex left handed
- Location:Karlstad, Sweden
- Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
- Learning:Java, C#
And, if you really need to, connect to the sql server via odbc from access. But I agree, stay on the sql server!
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall
I study Information Systems at Karlstad University when I'm not on CodeCall
#5
Posted 23 February 2012 - 06:04 AM
kent101
-
- Members
-
- 3 posts
Newbie
I agree, stay on the sql server, and if you really need to migrate your database, migrate it to another platform (access is poor), you can use a very useful tool called DbSchema.
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
