Building an import tool

Applications Control
#1

Has anyone got any pointers for building an import tool. I need to be able to do lookups for key fields, be database generic (mysql, oracle, and ms-sql), and read from csv, excel, and text files uploaded from the local computer. I’m not even sure what application type to start with for this project so any suggestions would be great.

  • Jason
#2

Re: Building an import tool

Hi,

I did a blank application with this code:

LOAD DATA LOCAL
INFILE ‘C:Tempwarehouse_sede.csv’
INSERT INTO TABLE warehose_sede
codice, name, desbre, descri
TERMINATED BY ‘;’
OPTIONALLY ENCLOSED BY ‘"’;

#3

Re: Building an import tool

But this works only on mysql?