table2text32.exe can't read file

More
5 years 10 months ago #17300 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

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #17302 by Peter.Jonson
Can you try disabling bulk fetch

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #17305 by sgenzen
1) what is the command to disable bulk fetch?
2) where can I get full documentation as to the command options?

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #17306 by sgenzen
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!!??
Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #17307 by admin
Run it without parameters and you will see help

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
5 years 10 months ago #17308 by sgenzen
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!!??
Attachments:

Please Log in or Create an account to join the conversation.