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.
[ Parent
| on HN ]
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.
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.