Importing from Excel to Access table
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:
Each date is a new record. I hope this makes some sense.