[ic] Automating Table Importation

[interchange-users@icdevgroup.org]

Adrian P Wilkinson wrote:
>
> We have a custom application running under Microsoft Access
> to handle the
> updating of stock and pricing information against the data
> provided by our
> distributors.  The end result is that we end up with a products and
> inventory table containing the most up-to-date price and
> stock levels
> according to a formula to determine where to purchase parts
> from.  Once this
> processing had been done we can export the data to text
> files ready for
> importation into Interchange.
>
> Is there any way that we can automate the importation of
> these two tables
> from a text file into the Interchange database (hosted on
> MySQL)?

I found this in my personal archives and also in the mail archives at
icdevgroup.org:

http://www.icdevgroup.org/pipermail/interchange-users/2002-June/021914
.html

Maybe this route would be better for you, maybe not.

Good luck!

Curt Hauge

//////////////////////////////////////////////////////////////////
// Web Design - Interchange Hosting - Small Business Consulting //
// 1644 133rd Ln NE                         www.mnwebdesign.com //
// Ham Lake, MN 55304                  www.iwantaconsultant.com //
// Phone 612-598-5530                      info@mnwebdesign.com //
//////////////////////////////////////////////////////////////////