Greetings everyone.  I've search and sorted and read the blog and read the manual.  Having a hard time finding import instructions.  I have an Excel sheet that I have exported into XML, then uploaded the file.  I have created and defined fields for my UDT, then tried to import the data from the XML file.  No luck.

Best links where I can read up on this and figure out what I'm doing wrong?
Any chance that comma or tab delimited file import will be made available for this module in the future?

Thanks in advance,
Chad

Thanks Sebastian, I guess I'm not sure how to do that.

When I export from my UDT I get this:

<?xml version="1.0" encoding="utf-8" ?><content type="DNNUserDefinedTable" version="03.04.00"><UserDefinedTable xmlns="DotNetNuke/UserDefinedTable">
  <Data>
    <UserDefinedRowId>1</UserDefinedRowId>
    <Title>Above All</Title>
    <Author>Leblanc, Lenny</Author>
    <CCLINo>2672885</CCLINo>
    <Key>G/A</Key>
    <Tempo>Slow</Tempo>
    <Scripture_x0020_References>&lt;p&gt;Description&lt;/p&gt;</Scripture_x0020_References>
    <Last_x0020_Sung_x0020_On>2008-01-22T00:00:00-05:00</Last_x0020_Sung_x0020_On>
    <Led_x0020_By>Jill or Chad</Led_x0020_By>
    <Themes>Majesty</Themes>
    <Changed_x0020_at>2008-01-22T14:52:30-05:00</Changed_x0020_at>
    <Changed_x0020_by>Websupport</Changed_x0020_by>
    <Created_x0020_at>2008-01-22T14:52:30-05:00</Created_x0020_at>
    <Created_x0020_by>Websupport</Created_x0020_by>
    <Last_x0020_Sung_x0020_On_UDT_Value>1/22/2008</Last_x0020_Sung_x0020_On_UDT_Value>
    <Last_x0020_Sung_x0020_On_UDT_Ticks>633365568000000000</Last_x0020_Sung_x0020_On_UDT_Ticks>
    <Created_x0020_by_UDT_Original>host</Created_x0020_by_UDT_Original>
    <Created_x0020_at_UDT_Value>1/22/2008 2:52 PM</Created_x0020_at_UDT_Value>
    <Created_x0020_at_UDT_Ticks>633366103500000000</Created_x0020_at_UDT_Ticks>
    <Changed_x0020_by_UDT_Original>host</Changed_x0020_by_UDT_Original>
    <Changed_x0020_at_UDT_Value>1/22/2008 2:52 PM</Changed_x0020_at_UDT_Value>
    <Changed_x0020_at_UDT_Ticks>633366103500000000</Changed_x0020_at_UDT_Ticks>
  </Data>
  <Fields>
    <UserDefinedFieldId>5</UserDefinedFieldId>
    <ModuleID>766</ModuleID>
    <FieldTitle>Title</FieldTitle>
    <Required>false</Required>
    <FieldOrder>0</FieldOrder>
    <FieldType>String</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Title</ValueColumn>
    <SortColumn>Title</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>6</UserDefinedFieldId>
    <ModuleID>766</ModuleID>
    <FieldTitle>Author</FieldTitle>
    <Required>false</Required>
    <FieldOrder>1</FieldOrder>
    <FieldType>String</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Author</ValueColumn>
    <SortColumn>Author</SortColumn>
  </Fields>

When I export from Excel, I get this:

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2008-01-22T14:41:14">
<User_x0020_Defined_x0020_Table>
<Title>Above All</Title>
<Author>LeBlanc, Lenny\Baloche, Paul</Author>
<CCLI>2672885</CCLI>
<Key>G/A</Key>
<Tempo>SLOW</Tempo>
</User_x0020_Defined_x0020_Table>
<User_x0020_Defined_x0020_Table>
<Title>Agnes Dei</Title>
<Author>Smith, Michael W.</Author>
<CCLI>2698333</CCLI>
<Key>A</Key>
<Tempo>MOD</Tempo>
</User_x0020_Defined_x0020_Table>
<User_x0020_Defined_x0020_Table>
<Title>Ain&apos;t No Rock</Title>
</User_x0020_Defined_x0020_Table>
<User_x0020_Defined_x0020_Table>
<Title>All Bow Down</Title>
</User_x0020_Defined_x0020_Table>
<User_x0020_Defined_x0020_Table>
<Title>All Hail King Jesus</Title>
<Author>Moody, Dave</Author>
<Key>F</Key>
<Tempo>MOD</Tempo>
</User_x0020_Defined_x0020_Table>

I am attempting this for the first time with a simple 12 column 82 row spread sheet.  Nothing fancy.

The part I am totally lost on is "adopt your import data to meet the same format".   How is this done in Excel 2007?  I have been playing with the import / export features for 2 days now and have been to numerous MS help sites but I am lost and frustrated now.

All other steps have been completed so far (recreate columns in UDT, added 'dummy data', exported the xml file [udt]).
Any help would be greatly appreciated.