The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
Excell file transfer inserting col1 |
Post Reply |
Author | ||||||||||||||||
bytebybyte
Newbie Joined: August 10 2016 Location: Australia Status: Offline Points: 3 |
Post Options
Thanks(0)
Posted: August 10 2016 at 6:31pm |
|||||||||||||||
We are transferring data from a D3 multivalue
database. The data is transferred to an Excel spreadsheet and the values in row 1 are being replaced with col1, col2 col3 for excell cells a1 , a2, a3.
Version of AccuTerm 7.0d sp2 (7.0.1412). Alex
|
||||||||||||||||
Alex
|
||||||||||||||||
PSchellenbach
Admin Group Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
|
|||||||||||||||
Hi Alex -
There is an option in FTD (or FTEXPORT) to enable or disable the first row of the worksheet as a heading row. If you disable this you should see the first row of data on the first row of the worksheet. Otherwise the first data row would be on the second row of the worksheet. Thanks, Pete |
||||||||||||||||
bytebybyte
Newbie Joined: August 10 2016 Location: Australia Status: Offline Points: 3 |
Post Options
Thanks(0)
|
|||||||||||||||
Pete,
Thanks. The problem we have is some PC are having row data replaced by "Col1'. Process has been running for years & recently we have some PC's having the problem. The D3 data to be transferred to excel: 0001 21487 0002 For NEW MOTOR VEHICLE 0003 NEW 0004 N 0005 GOVERNMENT 0006 BRISBANE ISUZU 0007 26 KERRY ROAD 0008 ARCHERFIELD 4108 The Excel s/sheet finishes with:
One PC window7 is Ok, a 2nd PC using WIndows 10 has the 'Col1' being inserted. Alex |
||||||||||||||||
Alex
|
||||||||||||||||
PSchellenbach
Admin Group Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
|
|||||||||||||||
Hi Alex -
First thing - update your version of AccuTerm to 7.1c-sp2 (the current release). You will probably see an error when you do the transfer. Normally, AccuTerm uses Automation with Excel to convert the text data from D3 into an Excel worksheet. But if Excel is not installed, there is a fallback converter that attempts to do the conversion. Its quite old and unreliable. The current version of AccuTerm will return an error from Excel if Excel is installed instead of using the fallback. Once you see the error, it will probably help sort out the solution. Thanks, Pete |
||||||||||||||||
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |