[AccessD] Importing multiple supplier price books

Haydn,

If all the books are in electronic format, then why not have them all
converted into XML?

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Wednesday 2003 Jul 09 15:52
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Importing multiple supplier price books


Well that's a hard one because you can't cunt on the supplier following
any standard of yours.  So I think you're stuck with a custom import
routine for each catalog.

If this is an ongoing project with new catalogs being added from time to
time, I'd set up a table to store a description of each supplier's
catalog and how their fields correspond to yours.  Then I'd make a form
to maintain that table so that you could hand the job of to a clerk who
could define and import the new catalogs as required.

Rocky

----- Original Message ----- 
From: "Hadyn Morgan" <hadyn at dataconcepts.co.nz>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, July 09, 2003 1:24 PM
Subject: Re: [AccessD] Importing multiple supplier price books


> The books are all in electronic format.  From .dat files to 
> formated/multi-sheet .xls files and everything in between.  Some have 
> only the required fields (code, desc, uom, trade, cost), others have 
> extra columns like category, brand, retail, etc.  Although the fields 
> may be common the order of the fields is not
>
> Kind regards
> Hadyn