Recent content by sam28bul

Thank you guys. Will try your suggestions.

Thanks for the link. I'm just trying to learn XSLT, so its not easy to attempt. :) With iteration code, I need to check if a found record already exists in the DB before importing it, since the folder structure is amended with new records daily, and the import code needs to run periodically.

Welcome to Access World Forums!

I'm learning too here.

Welcome to Access World Forums!

Welcome to Access World Forums!

Welcome from a newbie!

Thank you guys. :)

Of course its an option. But I need to show fields in tables and queries in a certain way. For example, links to audio files in the PATH field must be hyperlinks with title truncated to a file name only. I can edit it after importing, but it looks like XSLT provides a way to import data into...

XSL is a language for transforming XML. I'm not allowed to post links for now to show some Stack Overflow site examples for XML file transforms when importing them into Access. :)

Thanks for the simplified sample code. Yes, it seems possible to manually import subsequent XMLs to the same tables. I wonder if adding a basic XSLT code for XML file import transform would be a simpler approach to accomplish the entire task? It can be called from a VBA code iterating through...

I've my small office phone calls DB, saved now into multilevel enclosed folders structure by year, month, date (i.e. folder 2017 contains month folders 1,2,3...12, each of those contains day folders 1,2,3...30,31). Each day folder contains multiple pairs of XML and WAV files (named like this...

Hi everyone, I'm a newbie to Access and struggling to do it the right thing. :)