I just want to have the results from a simple select statement exported to excel. It seems like the only options now are grid or text. In previous versions this was obvious from the menu but now I can't find it at all! Am I missing something??
How to export from psql using pcc client version 11 to excel?
1.7k Views Asked by AZee At
1
There are 1 best solutions below
Related Questions in PSQL
- Postgresql trimming string up to the first digit
- PSQL Error Level in Batch For Loop
- How to violate duplicate key constraint (Unique_Violation) when updating reference table in PostgreSQL?
- psql max group by just for some columns
- PostgreSQL: MD5 Authentication in pg_hba.conf gives me FATAL: Peer authentication failed for user "postgres"
- psql TypeError: not all arguments converted during string formatting
- How do I make Postgres extension available to non superuser
- DEADLOCK Situation - SQL/Hibernate/Java how to resolve it?
- Rails - Simple Form with Nested Attributes
- FATAL: invalid value for parameter "TimeZone": "Australia/Canberra"
- Rails - PSQL command line query
- How do I dump a database from online server (heroku) to my local environment?
- Using psql options in npgsql
- python 2.6 subprocess enter psql password C shell
- pg_stat_statements enabled, but the table does not exist
Related Questions in PERVASIVE
- Export data from table in Pervasive
- Accessing Pervasive Database via Node.js on a Linux Server
- BTrieve open table not returning all rows
- DSN connection to remote pervasive database
- Can't create a query
- Need a Concatanate By Group Aggregate Command For Pervasive SQL
- ODBC connection works through command line, not through apache
- Getting the out parameter from my stored procedure
- SSIS Unable to Cast COM OBJECT
- How to export from psql using pcc client version 11 to excel?
- Pervasive-SQL, INNER JOIN with the UNION result
- Pervasive v11: Remove optional paramter in where clause
- Simplify many like statements
- SQL Server 64-bit ODBC Connection to 32-bit Pervasive SQL v10
- Is it possible to force a .NET dll running in a 32 bit process to 'act' like a 64 bit process?
Related Questions in PERVASIVE-SQL
- BTrieve open table not returning all rows
- How To Install Pervasive ODBC on Ubuntu Linux?
- Adding a Row Number to a Temp Table in Stored Procedure
- Stored Procedure - Outputing a temp table
- How to export from psql using pcc client version 11 to excel?
- Pervasive-SQL, INNER JOIN with the UNION result
- Combining columns into records for WHERE IN()
- What will be the connection URL, Driver class name and maven dependency for Pervasive db?
- Is it possible to group by a substring pervasive sql?
- Pervasive SQL(10.3) File size exceeding 2GB resulting in a .^01 file being created
- Failing to connect to pervasive database in Ruby on Rails using odbc
- How to use PSQL (pervasive) OR in PHP with a variable?
- Pervasive SQL System Stored Procedure from ADO.NET error
- How do you access Pervasive SQL metadata tables?
- Most efficient way to select records in one database based on result set from totally different database
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
A direct export to Excel isn't (and never has been) offered by Pervasive. You can export to CSV / SDF and open that file in Excel. In PSQL v11, you can export the data by right clicking the table name in PCC and selecting "Export Data".
If you want to export more than one table at a time or on a scheduled basis, you need a different tool.