I have a customer who has all of his data entered in on an excel spreadsheet.  Is there an efficient way to get the information from a flat database to a relational one.  I keep trying to copy and past multiple column but all the columns end up into one cell,and I can't transfer a whole record at once because all of the information is on different tables.  I was going to try and set up a form that would make this easier....What would you do?

---

Reply from Alex Hedley:

Highlight the table in excel.
Open Access, click in the Navigation Pane and Paste (Ctrl+V) and it will turn that into a Table.

You can then use the Table Analyzer - Tools, Analyze, Tables to split the flat file
MS Article 2002/2003/2007
It's not perfect but does a good job.

The better way is doing it yourself like shown in Expert Level 1. This shows how to make a Flat File into a relational db.