Can someone please point me out to where I can get good examples on how to transfer the data from .xml file into a table in database.
Thanks
Printable View
Can someone please point me out to where I can get good examples on how to transfer the data from .xml file into a table in database.
Thanks
You can easily trasnfer data from xml to datasets, but then transfering data to a database is sometimes a pain in the neck. If the tables and relations are pre built then you can easily tranfer it to database too. But if not you have to use make table queries for SQL Server and maybe ADOX for Access to build tables and relationships. Access has import xml feature but it does not import relationships.
There is a table in the sql database which can take the same fields in xml file. Do you know how to do this? Thanks