Thread: Other list - or answer?
Hello, My supervisor has requested that I copy a small database to Excel for her to look at. The first time I did it, I used the copy command and the data was so dirty that it didn't come in very well. Someone suggested that I use a pipe to delimit the data so that the Excel can ignore the commas that are imbedded in the data. I tried to do that and I'm having trouble with the syntax. Is there another list where I should bring this kind of query question? I have already searched for an answer on the postgres.org site, but didn't turn up anything useful for this. Thanks, Carol
Carol Walter wrote: > Hello, > > My supervisor has requested that I copy a small database to Excel for > her to look at. The first time I did it, I used the copy command and > the data was so dirty that it didn't come in very well. Someone > suggested that I use a pipe to delimit the data so that the Excel can > ignore the commas that are imbedded in the data. I tried to do that and > I'm having trouble with the syntax. > > Is there another list where I should bring this kind of query question? > I have already searched for an answer on the postgres.org site, but > didn't turn up anything useful for this. I would use Access, but if you have to use Excel, make sure you do it via ODBC so you don't have to clean up the data. J > > Thanks, > Carol > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/