MDBTools(1)MDBTools(1)NAME
mdb-parsecsv - Convert CSV table dump into C file.
SYNOPSIS
mdb-parsecsv file
DESCRIPTION
mdb-parsecsv is a utility program distributed with MDB Tools.
mdb-parsecsv takes a CSV file representing a database table, and converts it into a C array.
NOTES
If the first argument does not exist as a file, mdb-parsecsv will look for the same filename with '.txt' appended.
The file extension is stripped, and the output written to the base name plus a '.c' extension.
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
SEE ALSO gmdb2(1)mdb-export(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-header(1)mdb-schema(1)mdb-tables(1)AUTHORS
The mdb-parsecsv utility was written by Brian Bruns.
0.7 13 July 2013 MDBTools(1)
Check Out this Related Man Page
MDBTools(1)MDBTools(1)NAME
mdb-header - Write header file from an MDB database
SYNOPSIS
mdb-header [database]
DESCRIPTION
mdb-header is a utility program distributed with MDB Tools.
It will dump the names and types of the tables and columns in an MDB database in a C header format.
It will create three files - types.h and dumptypes.[ch]
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
EXIT STATUS
mdb-header exits with error code 1 if there was anunsupported type.
SEE ALSO gmdb2(1)mdb-export(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-parsecsv(1)mdb-schema(1)mdb-tables(1)AUTHORS
The mdb-header utility was written by Brian Bruns.
BUGS
Only a few types are currently supported.
0.7 13 July 2013 MDBTools(1)
Can anyone help.
I have sql to CSV showing header with ALIAS names but I want to generate CSV file with user friendly name i.e from AIAN8 to Adress Book Number etc.
SELECT AIAN8 || , || F0101.ABALPH || , || AICO ||
showing following below in CSV output intead of above
Address... (4 Replies)
I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ?
I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format .
The output should be like this 'a','b','c', (4 Replies)
Hi,
I am running a JDBC:ODBC code to access .mdb file in my windows system successfully but, not able to access MS Access mdb file in AIX Unix box. when I am trying to run the same piece of code in AIX Unix box it is saying "No Suitable Driver". I need some immediate help. (0 Replies)
hi..
I have a text file which looks likes this
2258
4569
1239
258
473
i need to convert it into comma seperated format
eg:2258,4569,1239,258,437
pls help (8 Replies)
Hi guys,
I am not experienced with Unix, so please dont mind if the question seem to be irrelevant.
I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail.
-I stored the query o/p in a file.
-I... (6 Replies)
Hi Guys, How All are Doing
In Perl I am getting an issue that I want to share with all you guys.
I have a .mdb file(MS Access) that contain many tables. With the help of Perl I want to Connect that mdb file and after Connecting I want to fire a sql query lets say (select * from Table1).
... (3 Replies)
I have a CSV file that needs to be loaded to a DB. It appears the copy utility expects fixed number of tokens per line so as to insert data into the corresponding database fileds. My input looks like
c1,c2,c3,n1,n2,n3
c1,c2,c3,n1,n2,n3,n4,n5,n6
c1,c2,c3,n1,n2
c1,c2,c3,n1,n2,n3,n4,n5,n6
... (7 Replies)
I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.
The issue is that all the data comes in to the same column, i want them to be separated in different columns.
SQL_COMMAND=command.sql
file=file.txt
formatFile=formatFile.txt
report=report.csv
echo... (1 Reply)
I have a CSV file with hdfs directories, hive tables and hbase tables.
1. first column - hdfs directories
2. second column - hive tables
3. third column - hbase tables
I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)