Hale, Jim
jim.hale at fleetpride.com
Wed Jul 9 13:01:16 CDT 2003
We do it the same way. Jim Hale -----Original Message----- From: Porter, Mark [mailto:MPorter at acsalaska.com] Sent: Wednesday, July 09, 2003 12:27 PM To: 'Access Developers discussion and problem solving' Subject: RE: [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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030709/da1465a6/attachment-0001.html>