title: How to export table structures and data from ms access as txt file
body: <p>I am new in ms access 
  In mysql we can export table structure as create query like the following</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `audio_master` (
    `audio_id` int(11) NOT NULL AUTO_INCREMENT,
    `audio_title` varchar(255) DEFAULT NULL,
    `course_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`audio_id`)
  )  
  
  
  INSERT INTO `audio_master` (`audio_id`, `audio_title`, `course_id`) VALUES
  (1, 'java audio', 1);
  </code></pre>
  
  <p>Like this I need to take from MS Access. How I can export like this using ms Access or sql server</p>
  
  <p>Any suggestions or answers highly appreciated</p>
  
  <p>Thanks in advance </p>