Announcement

Collapse
No announcement yet.

Building an import tool

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • jasonf1977
    started a topic Building an import tool

    Building an import tool

    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

  • aducom
    replied
    Re: Building an import tool

    But this works only on mysql?

    Leave a comment:


  • giovannino
    replied
    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 '"';

    Leave a comment:

Working...
X