Does anyone know if there is a solution to transfer data from oracle 8i to quickbooks 8.0?
Printable View
Does anyone know if there is a solution to transfer data from oracle 8i to quickbooks 8.0?
You certainly can transfer the data. Figure out what format Quickbooks wants, and create a query that will produce the correct output. So the following query would help you if you need comma delimited with double quotes.
Code:SET ECHO OFF
SET PAGESIZE 0
SET FEEDBACK OFF
SPOOL c:\quickbooks.csv
SELECT '"'||col1||'","'||col2||'","'||col3||'"'
FROM table1
WHERE col=666;
spool off;