cindy.endris
Newbie
- Local time
- Today, 08:28
- Joined
- May 29, 2008
- Messages
- 20
I need YOUR help!
I have set up my tables in .mdb with no data and I have set up my worksheets including the date exactly like my tables. I have succesfully exported 2 of my worksheets into 2 of my tables but the 3rd one didn't work.
I received a message stating:
“The first row contains some data that can’t be used for valid Access field names. In these cases, the wizard will automatically assign valid field names.”
I am aware that access has constraints on field names and I am compliance with it. What could be the problem? Below are my field names in the first row of my excel worksheet:
AflacCode
EmployeeCode
Aflac_Pol
Aflac_Cov
Aflac_Prem
AflacAnni
AflacBene
Since I received this message above, I allowed the wizard to assigned valid field names but I received another pop-up message. It stated:
“An error occurred trying to import file ‘Administration.xls’. The file was not imported.”
Since I got the above message, I deleted the field names in the first row in excel but the wizard didn’t give me the option to put it in an existing table (see below).
Any suggestions? I appreciate any information you have to share. Thanks!
I have set up my tables in .mdb with no data and I have set up my worksheets including the date exactly like my tables. I have succesfully exported 2 of my worksheets into 2 of my tables but the 3rd one didn't work.
I received a message stating:
“The first row contains some data that can’t be used for valid Access field names. In these cases, the wizard will automatically assign valid field names.”
I am aware that access has constraints on field names and I am compliance with it. What could be the problem? Below are my field names in the first row of my excel worksheet:
AflacCode
EmployeeCode
Aflac_Pol
Aflac_Cov
Aflac_Prem
AflacAnni
AflacBene
Since I received this message above, I allowed the wizard to assigned valid field names but I received another pop-up message. It stated:
“An error occurred trying to import file ‘Administration.xls’. The file was not imported.”
Since I got the above message, I deleted the field names in the first row in excel but the wizard didn’t give me the option to put it in an existing table (see below).
Any suggestions? I appreciate any information you have to share. Thanks!