I have VS.Net Enterprise Architect Beta 3 installed and have starting playing around with it. I’d like to use some Excel files as a data source and have been reading up on ADO.Net. I also have SQL Server installed and can get the sample databases to load in a datagrid (with help from a book I have) so that part works fine.
From what I’ve been reading so far, the data source can be pretty much anything from a text file, XML, spreadsheet, etc. I can’t find any examples, though on reading Excel spreadsheets. How do they need to be formatted to be read as a datasource? I have seen references to this but no sample code, all samples are for regular database tables. 
Do I put each ‘table’ on its own sheet? Do I need column heades that match the field names in the destination database table? 
Thnx, Deb
