[AccessD] Importing multiple supplier price books

You could use XSLT to convert the text files to XML then into a 
recordset, I have seen XSLT to convert CSV files to XML among others but 
this might be a bit more diificult than getting suppliers to submit in XML.

 Here is a recent VB MSKB article on converting Text files to an mdb.


  ImportText.exe Importing Text into Access with
  ADO/RDO/DAO/Filesys/Automation


http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q230265

Wortz, Charles wrote:

>Haydn,
>
>If all the books are in electronic format, then why not have them all
>converted into XML?
>
>Charles Wortz
>Software Development Division
>Texas Education Agency
>1701 N. Congress Ave
>Austin, TX 78701-1494
>512-463-9493
>CWortz at tea.state.tx.us
>
>
>
>-----Original Message-----
>From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
>Sent: Wednesday 2003 Jul 09 15:52
>To: Access Developers discussion and problem solving
>Subject: Re: [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
>>    
>>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>