I have a question for how tocompare two tables fieldname and then make them to be corresponded. The original file could be CSV or EXCEL, the destination table is ACCESS. How to use VB coding to program two tables fieldname to be corresponded and then using this corresponded reference table to convert CSV and EXCEL file into ACCESS table?
In addition, the history correspondence can be memorized to make this function more clever?
__________________________________________________ ___________
For example:
Original CSV/ EXCEL file:
First_Name,Last_Name,Title,Company,Phone,Fax,Phone _-_Mobile,Email,Web_Page
Jadp,Daas,Sr. Product Manager,Saabase Inc.,(955) 236-5214,(955) 236-6179,,jaadpdas@sabase.com,www.sabase.com
Jbdp,Dbbs,Sr. Product Manager,Sbbbase Inc.,(955) 236-5214,(955) 236-6179,,jbbdp.das@sbbbase.com,www.sbbase.com
Destination ACCESS table structure:
ContactFirst,ContactLast,ContactTitle,ContactCompa ny,ContactPhone,ContactFax,ContactMobile,ContactEm ail,Contactwebpage
------------------------------------------------------------------------------------------------------
Any helps and guidence will be greatly appreciated.
Best Regards,
Anne36