[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