- Posts: 4
- Thank you received: 0
table2text32.exe can't read file
5 years 10 months ago #17300
by sgenzen
table2text32.exe can't read file was created by sgenzen
I am able to read the data source just fine in excel - but ... am getting the following error
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";USER=sam;PASSWORD=sam;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";USER=sam;PASSWORD=sam;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
5 years 10 months ago #17302
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic table2text32.exe can't read file
Can you try disabling bulk fetch
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
5 years 10 months ago #17305
by sgenzen
Replied by sgenzen on topic table2text32.exe can't read file
1) what is the command to disable bulk fetch?
2) where can I get full documentation as to the command options?
2) where can I get full documentation as to the command options?
Please Log in or Create an account to join the conversation.
5 years 10 months ago #17306
by sgenzen
Replied by sgenzen on topic table2text32.exe can't read file
still having same issue
clip
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";DISABLEBULKFETCH=TRUE;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
clip
you can see the attached screenshot showing it does work with excel!!??
clip
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";DISABLEBULKFETCH=TRUE;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
clip
you can see the attached screenshot showing it does work with excel!!??
Please Log in or Create an account to join the conversation.
5 years 10 months ago #17307
by admin
Mike
ETL Architect
Replied by admin on topic table2text32.exe can't read file
Run it without parameters and you will see help
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
5 years 10 months ago #17308
by sgenzen
Replied by sgenzen on topic table2text32.exe can't read file
Might you possibly help me resolve why it still doesn't run with DISABLEBULKFETCH=TRUE
clip
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";DISABLEBULKFETCH=TRUE;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
clip
you can see the attached screenshot showing it does work with excel!!??
clip
C:\csv>.\table2text32.exe DSN="QuickBooks POS Data";DISABLEBULKFETCH=TRUE;TABLE=Department;FILE=c:dept.csv;DELIMETER=TAB
Table2Text Export Utility - Version 2.2.0.2
Copyright (c) 2008-2017 DB Software Laboratory
Not able to read the data
clip
you can see the attached screenshot showing it does work with excel!!??
Please Log in or Create an account to join the conversation.