Recent content by zezo2021

Hello I find the answer here: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output indent="yes"/> <xsl:strip-space elements="*"/> <xsl:template match="/"> <dataroot> <xsl:apply-templates select="@*|node()"/>...

Yes I need a relationship between Father and soon how can I do that in the attached xslt I don't understand. I am not familiar with your English I hope not contain something wrong or a mystery the family relation is an example I give you the actual tables 1 2 3 I need to create a relation...

If I have an XML file that contains the following branches: grandfather table, father table, and son table, I have linked the grandfather table to the father table as shown in this code. However, I was unable to link the son table to the father table because there is no linking number PK in the...

Can you please convert this XML to XLST to get PK with FK with all tables to use with the transform command when importing XML or give me your feedback about this XML can be done? is this XML fit in access to create relations between tables after importing

Hello Is there a code to import XML file and pass transform file also then convert the file to tables I want to convert import XML wizard to code but must access transform files Thanks

do you mean add PK and FK to table design And start filling blank rows with FK and PK

?

Thank you for your reply is this method can create relations from XML in the attached image Application.ImportXML add a shared field in the tables under company when imported (for example) companyID because it imports all tables under the company to separate tables with no shared filed (PK)...

friends a client sent me xml containing a lot of tables When used this method Application.ImportXML every tag created on a separate table my question: when opening access tables after importing form XML not see shared fields between these tables. is this error or Is there something...

The client is a man of few words and has not requested a meeting or sent any questions. He said he wants results, but he does not understand what he wants.

Thank you CLIENT gave ME A set of 10 text files with ambiguous data and no field descriptions, I uploaded them and discovered that each converted file had a repeating foreign key but no primary key. The task was to join these files together. I proposed two solutions: 1. Linking all foreign...

I'm trying to find another solution asap

Hello friends; I'm using this code to search in Excel Table and display the result in LISTBOX On USERFORM but I think this code is complex do you have another code? Can you suggest an easier code? Private Sub TextBox1_Change() Dim Data, Arr, Crit As String Crit = TextBox1 With...

(y) I solve the problem after viewing your post Can you check the DB? after the solution is applied and give a feedback

I have 2 Tables in attached DB Imported And AllDataSource I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table 1- Append Data from Imported Table To AllDataSource 2- if record exists...