I have a relatively simple spreadsheet that i am trying to import into a table (Office 2007). The data is copied from one tool (Primavera P6 - Proj. Mgmnt. Application) into excel - all good - top row contains field names.
The data i am copying across is number of hours per month against different pieces of work - much like a crosstab.
The problem i am having is with the months that don't have any hours in. Access is unable to correctly name the field, it provides me with the format dd-mmmm-yyyy 00:00:00.
If the field has data in, i get dd-mmm-yy, which is correct.
Question is twofold:
1) - any idea why this is happening?
2) - More importantly, any way of getting Access to pull the column headings through correctly.
The spreadsheet itself cannot be modified hugely as i need to allow for all eventualities, ie someone might well accidentally forecast hours in the past, indeed this is one of the reasons i'm attempting to build this little database in the first place; to check for errors.
Thanks for any help you can offer - i get the feeling this is probably a simple one.
The data i am copying across is number of hours per month against different pieces of work - much like a crosstab.
The problem i am having is with the months that don't have any hours in. Access is unable to correctly name the field, it provides me with the format dd-mmmm-yyyy 00:00:00.
If the field has data in, i get dd-mmm-yy, which is correct.
Question is twofold:
1) - any idea why this is happening?
2) - More importantly, any way of getting Access to pull the column headings through correctly.
The spreadsheet itself cannot be modified hugely as i need to allow for all eventualities, ie someone might well accidentally forecast hours in the past, indeed this is one of the reasons i'm attempting to build this little database in the first place; to check for errors.
Thanks for any help you can offer - i get the feeling this is probably a simple one.