I've attached the excel and access screenshots.
coding to put an excel file data into a MS access table?
The table name would be "apciti"
The field names are... PMCO, PMLOC, PMIPMT, PMEPMT, PMEDOC, PMCURI, PYORPM, PYDATE, PMVNCD, VENNAM, VADR1, VADR2, VADR3, PMORPT, PMPMTT, PMPSLN, PMDOCT, PMACDT, PMCRDT, PMCRTT, PMCROP. Primary Key would be APCITID - auto gen with increment of 1
All contents are in the excel file.
SOrry for the changes.. The user suddenly changed the requirements
|