You may open an XML file in Excel using two different methods – a) using the File menu and b) using the Data menu. Note: An XML file contains data that’s been arranged within tags.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

And I already know how to read in an XML file and view it's contents.<BR><BR>So then, to input my XML file into Access I read in the XML file, move through it, and generate "Insert" SQL command ...

Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL.