<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Importing multiple supplier price books</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>We do it the same way.</FONT>
<BR><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Porter, Mark [<A HREF="mailto:MPorter@acsalaska.com">mailto:MPorter@acsalaska.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 09, 2003 12:27 PM</FONT>
<BR><FONT SIZE=2>To: 'Access Developers discussion and problem solving'</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Importing multiple supplier price books</FONT>
</P>
<BR>
<P><FONT SIZE=2>You may have to create an import routine for each individual supplier.</FONT>
</P>
<P><FONT SIZE=2>When I encounter situations like this, I have a seperate import routine for</FONT>
<BR><FONT SIZE=2>each data source to a temp table specifically for that source, then I move</FONT>
<BR><FONT SIZE=2>from the temp table to the main data table and groom the data to a common</FONT>
<BR><FONT SIZE=2>format at that stage.</FONT>
</P>
<P><FONT SIZE=2>I have not used this method for more than 5 data sources though.</FONT>
</P>
<P><FONT SIZE=2>Mark</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Hadyn Morgan [<A HREF="mailto:hadyn@dataconcepts.co.nz">mailto:hadyn@dataconcepts.co.nz</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, July 08, 2003 9:32 PM</FONT>
<BR><FONT SIZE=2>To: AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] Importing multiple supplier price books</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi Listers</FONT>
</P>
<P><FONT SIZE=2>I have an app. that works with multiple suppliers and their price books.</FONT>
<BR><FONT SIZE=2>The price books come in all shapes, styles and sizes. I need a solution to</FONT>
<BR><FONT SIZE=2>make the importing of these simple and accurate. Does anyone have one they</FONT>
<BR><FONT SIZE=2>would like to share/sell. I would hate to reinvent the wheel if I could</FONT>
<BR><FONT SIZE=2>avoid it. Maybe something to match columns with columns.</FONT>
</P>
<P><FONT SIZE=2>Any suggestions/help appreciated.</FONT>
</P>
<P><FONT SIZE=2>Kind regards</FONT>
<BR><FONT SIZE=2>Hadyn</FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>This transmittal may contain confidential information intended solely for</FONT>
<BR><FONT SIZE=2>the addressee. If you are not the intended recipient, you are hereby</FONT>
<BR><FONT SIZE=2>notified that you have received this transmittal in error; any review,</FONT>
<BR><FONT SIZE=2>dissemination, distribution or copying of this transmittal is strictly</FONT>
<BR><FONT SIZE=2>prohibited. If you have received this communication in error, please notify</FONT>
<BR><FONT SIZE=2>us immediately by reply or by telephone (collect at 907-564-1000) and ask to</FONT>
<BR><FONT SIZE=2>speak with the message sender. In addition, please immediately delete this</FONT>
<BR><FONT SIZE=2>message and all attachments. Thank you.</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>