Append Query Field Name Problem

[gthull644]

When I produce an append query that has field names such as 2007/08, the field name is truncated to 2007/8, which results in the query failing. SQL:

INSERT INTO [tblTemp Input] ([2007/08], [May-07]

Becomes:

INSERT INTO [tblTemp Input] ([2007/8], [May-7]

when the query is saved and re-opened.

I could rename the fields of the source table but is there an easier solution?

I am using Access 2003.

 

[Ian Mac]

Wrong Forum,

You need to post this in the Query Forum.

However I would consider looking at the structure of your database before you run into more problems in the future.
A table shouldn't really have a field named 2007/08

It would be best to have something like

Year (or FinancialYear/AcademicYear)
MonthYear

Better still would be just a Date field called WheteverDate.