B
Bob H
I have collected local weather records for the last 12 years and put the
figures into an Excel spreadsheet. Each year is 1 workbook, so I have 12
workbooks/spreadsheets worth of data which has a heading for each month
horizontally in that workbook. Then each month has a date or day listing
vertically, with data for the different readings I have collected for
each day.
I have looked at trying to import each workbook, but it doesn't look
right in Access 2007. The data is there, but the field names are F1, F2
etc, just like it is in the spreadsheet, with the Year and month fields
set 2 or 3 rows down. I couldn't changeb the field names during the
import process, because access 2007 told me that the field names were
invalid field names and couldn't be changed.
Any pointers please.
Thanks
figures into an Excel spreadsheet. Each year is 1 workbook, so I have 12
workbooks/spreadsheets worth of data which has a heading for each month
horizontally in that workbook. Then each month has a date or day listing
vertically, with data for the different readings I have collected for
each day.
I have looked at trying to import each workbook, but it doesn't look
right in Access 2007. The data is there, but the field names are F1, F2
etc, just like it is in the spreadsheet, with the Year and month fields
set 2 or 3 rows down. I couldn't changeb the field names during the
import process, because access 2007 told me that the field names were
invalid field names and couldn't be changed.
Any pointers please.
Thanks