Does XML do this?

[florida]

I am new to XML and was wondering if I could use it to take Excel 2000 spreadsheet data:
City State Name Age
Miami Florida Jones 34
Atlanta Georgia Smith 56
Dallas Texas Baker 43

and transfer it to Access 2000 where it will split it up into two tables:

TableOne
Id City State
1 Miami Florida
2 Atlanta Georgia
3 Dallas Texas

TableTwo
Id Name Age
1 Jones 34
2 Smith 56
3 Baker 43

[Alex Vincent]

Likely the answer is no. XML in this context is not a scripting language - it is a language for storing data.

I could be wrong, though; it could be a feature of Excel to export XML which Access could import. But for the 2000 series, I'm fairly sure it wasn't supported.