News for hackers. Stuff that matters.
Re:Excel and SQL by jpitz on Thursday May 23, 2013 @08:39PM (#5760529)
JET's days are long gone. The SQL Server Desktop engine is the underpinning for Access now. It essentially _is_ SQL Server. The biggest limitation? The concurrent transaction count is limited to 5. There are others, but it is a far, far cry from that prone to corrupt, slow beast JET.
Re:Excel and SQL by jrarredondo on Thursday May 23, 2013 @10:41PM (#5760974)
Actually, in the latest Office 2012, Access apps are now three tier apps with SQL Server 2012 or SQL Azure backends.
Re:Excel and SQL by panderon on Saturday May 25, 2013 @12:22PM (#5767675)
Point of clarification, concurrent transaction count is limited to 255. http://office.microsoft.com/en-us/access-help/access-2010-sp...
Re:Excel and SQL by moron4hire on Thursday May 23, 2013 @09:52PM (#5760800)
JET isn't all that bad. It can be used to run SQL queries CSV files. As an ETL tool it's pretty flexible.
Re:Excel and SQL by fusiongyro on Friday May 24, 2013 @10:12AM (#5762852)
It's amazing how much things change when you're not paying attention. Thanks for explaining this.