We are doing something like that with one customer who provides a xls spreadsheet. We link that spreadsheet to an access table and then do queries that create SOHEAD, SOLINE and SONOTES tables. From those table we create a flatfile (there is a special layout map available). This flatfile can then be imported into the EDI module under "Import EDI orders".