Want to Create Reports in Access and according to that Reports i have to generate PDF

Through my VB code i am reading an Excel sheet and dumn the data of Excel Sheet in MS Access table.This part is working fine now but the problem is this
according to a field name Vendor no i have to create MS Access report dynamically,what i mean to say that if i have 3 same vendor number so when i am inserting the Excel data in Access table at that time only i have to generate an Access report based at the vendor no and generate a PDF file for that Vendor no.All the procedure is in a loop becuase we have different vendor numbers so when the process of one vendor number completed code should search for the next vendor no and do the same process insert it into Access table,create access reports for that vendor number and make a PDF file for that vendor.Please some one help me out its very urgent.
Thanx in Advance

Moved from ClassicVb.