If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Launching Excel from Paradox 7

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-26-04, 08:41
pbare pbare is offline
Registered User
 
Join Date: Aug 2004
Posts: 16
Exclamation Launching Excel from Paradox 7

Is it possible to open EXCEL from within a Paradox 7 app.

I have a system that requires that I create a .csv file from a Paradox table and I have that working correctly, except that when the file is created, double quotes are placed around all the header fields and all string fields.

When my user attempts to load this file into a different program, it complains on the quotes that are in the file.

I am using the following code in order to create the .csv file and I haven't found anything that allows me to not add the quotes around the fields.

tbs = "J:\\enterpriseone\\teste1\\finance\\to_e1\\gibson _" + vHrsVol + ".csv"
dt.setSource (getAliasPath(":WORK:")+"\\"+"upload_e1.DB" )
dt.SetDest (tbs, dtAsciiVar)
dt.setDestFieldNamesFromFirst(TRUE)
dt.setDestSeparator ( "," )
dt.transferData ( )

Any help would be greatly appreciated since this needs to be completed as soon as possible.

Thanks,
pbare
Reply With Quote
  #2 (permalink)  
Old 10-27-04, 18:27
Shores Shores is offline
Registered User
 
Join Date: Aug 2003
Location: Bologna - Italy
Posts: 209
As i already told you in the other thread, simply do it yourself: instead of using the datatransfer object, use the textstream object and directly writing chars to it, so that you can totally control which fields get surrounded by what chars, and any other kind of decision on the destination text file.
__________________
The only failure is not trying to do it.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On