Recent content by live2ride

i agree 100%, as much as i hate multi value fields, im afraid i have no choice in this matter. our company sharepoint site was designed by other ppl and i have no control over that, but i have to grab the info from our sharepoint site. in my database there are no multi value fields but for those...

for anyone looking for answer to this heres the solution lets say you have 2 tables tblMyTable, tblImportedTable tblImportedTable has multi value fields. create new table tblValues and add records one at a time of the multi values. so lets say tblImportedTable has field colors with records as...

i have table on sharepoint which i can not link to my access database so i have to import it. table on sharepoint is same as in access and i need table from sharepoint updated with my access. unfortunately this table has multi valued fields. when i import table from sharepoint it, the table gets...