IT Employment

General discussion

Problem Copying & pasting an Access record into Excel

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

Try the SQL request from EXCEL to your database in ACCESS

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=LinkolnI think, that it simple example will help you to solve your problem.Sincerely, LukCAD

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.