Export Word Tables to XML

[SprintFlunky]

I have a document with 500+ tables. I want to export the tables into an Access database. Can this be done using XML as a transport. I don't want to have to define each table in the VBA code as that would take to long.

Any ideas on the easiest way to copy lots o word tables to Access?

Thanks,

 

[Chance1234]

need bit more information on the word tables themselves,

Chance,

Filmmaker, taken gentleman and countdown to lucrative licence deal

 

[SprintFlunky]

The Word document contains text as well as 500+ tables. some of the tables have the same format (columns types) but most look a little different. Want I need to do is export the tables into a format that I can put into an Access database or put them directly into Access (prefered).

All of the tables have column headings so I should be able to use those as field names in the Access Database and I can use the Word table name as the Access table name.

This is a one time deal (I hope) so I don't want to spend a lot of time on the code, but I don't want to go through the document table by table and cut and paste.

Thanks again for any help you can provide.

 

[Chance1234]

What im thinking is ,

Loop through the tables in the document
USe the cell property to return your column heading in the first cell of the table.

Pass that to Access, use createtabledef with the name, and then loop through adding in the data.

Dont think you need XML.

Chance,

Filmmaker, taken gentleman and countdown to lucrative licence deal