Announcement

Collapse
No announcement yet.

Building an import tool

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

  • 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

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

    Comment


    • #3
      Re: Building an import tool

      But this works only on mysql?
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment

      Working...
      X