Convert Access Form to Excel

66

There is the ability to export tables in Access to Excel. Using Access 2007, after opening the table go to the External Data tab and in the Export block click on the Excel button (it has the icon of a table in Datasheet view with an Excel icon in front of it).

Export Access to Excel

Share:
66

Related videos on Youtube

Priyatham
Author by

Priyatham

Updated on September 17, 2022

Comments

  • Priyatham
    Priyatham almost 2 years

    The following is the log.php file that is running on google app engine locally (on localhost).

    <?php
    if (isset($_POST['name'])) {
        $name = $_POST['name'];
        $filename = "log.txt";
        file_put_contents($filename, $name, FILE_APPEND | LOCK_EX);
    }
    ?>
    

    I am calling the above file using the following jquery call:

    $.ajax({
        url: './php/log.php',
        type: 'POST',
        data: {name: name},
        success: function (data) {
            console.log(data);
        }
    });
    

    I believe the ajax is working as I get a log on console which is just the entire php code. But the php is not writing anything into the log.txt file. Can anyone please help?

    • Priyatham
      Priyatham over 10 years
      There aren't any. As I have already said, the console output is just the whole php code.
    • floww
      floww over 10 years
      you should specify the used JSframework (jQuery?) and think about your prblem. i can not see any output to log n console and i personally can not understand the problem at all.
  • Omar
    Omar over 13 years
    If the access db has forms, how can I navigate to the table?
  • Xantec
    Xantec over 13 years
    sorry i have taken so long to respond. on the left hand side of the screen in Access is there a panel that fills the window from just beneath the ribbon to the bottom on down? if yes, does it say "Forms" at the top left with a little down arrow next to double arrows pointing left at the top right? if yes again, if you click the down arrow can you select "Tables and Related Views" under "Navigate to Category"? if you answered yes again then you should now be seeing all the tables in the database.