P
pjdevitt
Guest
I often copy & paste a query results set (from grid layout) into an Excel file, but I can't figure out a way to copy the column headers as well. Anyone have a solution?
Thx,
Patrick
Thx,
Patrick
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
pjdevitt said:I often copy & paste a query results set (from grid layout) into an Excel file, but I can't figure out a way to copy the column headers as well. Anyone have a solution?
Thx,
Patrick
In MS Excel, try this:
- From the menu bar, click "Data".
- Select "Import External Data".
- Select "New Database Query".
- Choose the DSN to your database (create one if you don't have one yet).
- Provide credentials when prompted for login, click "Options" and select the database from the list.
- Select your table.
- Follow the proceeding prompts (which are self-explanatory) and you should get the result on an excel worksheet with column headers.