Dave
Have you tried importing an Excel table into Access? If your Excel data is
organized in columns, it should import and give you the option of using the
first row as a field name.
Now the bad news ... if you've been working with Excel, odds are high that
your data is well-designed for a spreadsheet. Unfortunately, this could
make it poorly designed for a relational database (Access). Take the time
to review normalization and set up Access data structure accordingly.
You can still import the raw data, but you may then need to do some
append/update queries to parse the data into a more normalized form.
