[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
>
> ----- Original Message ----- 
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Thursday, July 10, 2003 1:30 AM
> Subject: Re: [AccessD] Importing multiple supplier price books
>
>
> > Hayden:
> >
> > Are the books available electronically?  Format?  Common fields?
> >
> > Rocky Smolin
> > Beach Access Software
> >
> > ----- Original Message ----- 
> > From: "Hadyn Morgan" <hadyn at dataconcepts.co.nz>
> > To: <AccessD at databaseadvisors.com>
> > Sent: Tuesday, July 08, 2003 10:31 PM
> > Subject: [AccessD] Importing multiple supplier price books
> >
> >
> > > Hi Listers
> > >
> > > I have an app. that works with multiple suppliers and their price
books.
> > > The price books come in all shapes, styles and sizes.  I need a
solution
> > to
> > > make the importing of these simple and accurate.  Does anyone have one
> > they
> > > would like to share/sell.  I would hate to reinvent the wheel if I
could
> > > avoid it.  Maybe something to match columns with columns.
> > >
> > > Any suggestions/help appreciated.
> > >
> > > Kind regards
> > > Hadyn
> > >
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>