I have a spreadsheet that contains work schedule information. Employees name's are in column A, in columns b-AF days of the month.I need to take this information and out in a table in access. The table consist of First name, last name, date worked. If I import using the File/get external data I get the column headings as field names such as 3/19/07 and 3/20.

I need for the program to write the data as:

rec#1
Mike
Jones
3/19
Rec#2
Mike
Jones
3/20
etc.

Each date is a new record. I hope this makes some sense.

Thanks!

The best way to do this would be to open the spreadsheet in Access and have it process each line.
In MS Access click Tools > References and add "Microsoft Excel 11.0 Object Library" by checking it.

Now you can open excel files and reference them just as you would in Excel by opening them like this:
-------------------------------------------------------------------------------------------
  Dim oWorkbook As Excel.Application, oSource As Worksheet
  Set oWorkbook = CreateObject(Class:="Excel.Application")
  oWorkbook.Visible = False 'Set to true if you want to see the opened workbook being processed
  oWorkbook.Workbooks.Open "c:\my.xls"
  Set oSource = oWorkbook.ActiveWorkbook.ActiveSheet
  ~~~Your Handling Code Here, ie rsMyRecordset("This Field") = oSource.cells(iRowOn,iColumnOn)~~~
  oWorkbook.ActiveWorkbook.Close SaveChanges:=False 'Set to true changes were made that you want to save
  oWorkbook.Quit
-------------------------------------------------------------------------------------------
You can read or write to the workbook as you would from within Excel.

This assumes you know how to add records to the database via code already and how to handle looping through spreadsheet data to extract what you want. Probably a set of nested do/while loops would be best.

Hope this helps.

You can also open the recordset from within Excel but requires a connection string. I didn't show this because I'm not aware of any of the information about the database necessary to build it for you.

thanks for help allenm