title: Easiest way to generate INSERT statements from MS Access data
body: <p>I have a bunch of data in MS Access.  I want to create INSERT statements from the data with the purpose of running them in SQL Server.  The table structure between Access and SQL Server is the same.  I don't have the option of doing an export/import because I don't have direct access to the SQL Server.  It is a web host's server and they only give you a stupid control panel to run scripts.  Unfortunately I can't use SQL Server Management Studio against it, or any other tools.</p>
  
  <p>What is the easiest way to generate SQL Server compatible INSERT statements from MS Access data?</p>