Importing csv files

tobyfreak · #1 (**permalink**) 12-11-02, 08:44

Hello,

I have a general problem importing CSV files into an informix db. How can I import an csv file? I´m using dbaccess and odbc connection to ms access...

please help!

Tobias

Roelwe · #2 (**permalink**) 12-11-02, 09:36

You can use simple sql:
load from 'file.csv' DELIMITER ','
INSERT INTO table

or you could use teh High Performance loader.

Manual are available on the internet:
http://www-3.ibm.com/software/data/i.../pubs/library/

tobyfreak · #3 (**permalink**) 12-11-02, 10:02

thanks for the hints...
when using dbaccess, how do i transfer the csv files to the db server?

Tobias

Quote:

Originally posted by Roelwe
You can use simple sql:
load from 'file.csv' DELIMITER ','
INSERT INTO table

or you could use teh High Performance loader.

Manual are available on the internet:
http://www-3.ibm.com/software/data/i.../pubs/library/

Roelwe · #4 (**permalink**) 12-11-02, 10:31

If you use dbaccess, dbaccess will look in the directory where you started dbaccess. So you 'll have to ftp the csv files to the dbserver.
You can also specify the full path name in the LOAD FROM clause

tobyfreak · #5 (**permalink**) 12-11-02, 12:28

Thank you Roelwe for your help!

Quote:

Originally posted by Roelwe
If you use dbaccess, dbaccess will look in the directory where you started dbaccess. So you 'll have to ftp the csv files to the dbserver.
You can also specify the full path name in the LOAD FROM clause

Internet Services

Web Development

Digital Marketing

Consumer Tech