General discussion

  • Creator
    Topic
  • #2176801

    Problem Copying & pasting an Access record into Excel

    Locked

    by misubs ·

    Does anybody know how to copy & paste a single record from an Access table into an Excel worksheet WITHOUT without getting the Header record from the Access table? This is a great annoyance as after the paste it is necessary to delete the Header record from the Excel worksheet, a lot of wasted keystrokes and time. Thanks in advance for any insight to this problem.

All Comments

  • Author
    Replies
    • #3330145

      Try the SQL request from EXCEL to your database in ACCESS

      by lukcad ·

      In reply to Problem Copying & pasting an Access record into Excel

      The methodology of saving data into database provide the SQL request from editors. ACCESS is the data base where every record or groupe of resords can be retrieved from EXCEL by request to external database. You will need only knowledge about four sql command to create sql request. For example: You need field USER where USER=Linkoln from database CLIENTS. Simple request will next: SELECT USER DROM CLIENTS WHERE USER=Linkoln
      I think, that it simple example will help you to solve your problem.
      Sincerely, LukCAD

    • #3330129

      Just export it as a CSV or text delimited list from Access

      by oz_media ·

      In reply to Problem Copying & pasting an Access record into Excel

      You will be given a choice of just one record, the entire lookup or the entire database.

      When you are confirming the field export options you should have the option to include or exclude header data.

Viewing 1 reply thread