[AccessD] Importing multiple supplier price books

You may have to create an import routine for each individual supplier.

When I encounter situations like this, I have a seperate import routine for
each data source to a temp table specifically for that source, then I move
from the temp table to the main data table and groom the data to a common
format at that stage.

I have not used this method for more than 5 data sources though.

Mark

-----Original Message-----
From: Hadyn Morgan [mailto:hadyn at dataconcepts.co.nz]
Sent: Tuesday, July 08, 2003 9:32 PM
To: AccessD at databaseadvisors.com
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


This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.