I have XML files and .h files on a single folder. A have a table with the following record structure: a song code following by 10 XML files and 4 .h files. Ex. song_code 00235 00235_01.xml 00235_02.xml.... 00235_10.xml and 00235_01.h 00235_02.h...00235_04.h Is it possible to attach the XML files and .h files to existing records on a database? I created a table with the type field attachment for the XML and .h files records; but, when I tried to add records I got an error message. I also wonder the following. I know the exact XML and .h filenames used on each record. Can I create some sort of a path filename similar to storing the path on an image in a text filed, and use some kind of control to attach the contents of the xml files and .h files?
Thanks very much
Code:
INSERT INTO XML ( [Song Code], [04 APP], [04 EXP], [04 MOD], [04 SEQ] )SELECT PythonXML.Field1, PythonXML.Field2, PythonXML.Field3, PythonXML.Field4, PythonXML.Field5
FROM PythonXML;