Access to MS SQL format
I am using an academic version of Visual Studio 2010 with C# as my language of choice. I am trying to create a rather data heavy site. It seems that MS Access is an inferior choice for a database compared to MS SQL.
My question is simple: Is it possible to convert an Access, Excel, flat file to an SQL format in a file that is permanent? Unsavable file conversions are of course possible using the free version of the Management Studio. I've tried some third-party utilities but they require a full MS SQL server license, not what comes with VS 2010.
Any suggestions are most welcome. If there is not a fix, PHP/MySQL might just get my business.
Excellent book by the way.