Excel to MS Access 2007 Import Field Name Errors

I am getting an error on a few field names when I import the attached file (tab 2) into MS Access. The fields are all essentially in the same format so I am baffled as to why some work and some don't. I know there is a logical explanation since there always is but I need your help on this one. I searched the internet and found some references to this problem but no sure answer. The second tab is named "2008-2009 Grants". I tried inserting an underscore between each word in the field name and took out any slashes but that did not help.

Thanks, Janis
EE-Estimated-Liability-Workbook-.xlsx
DMKetcherAsked:
Who is Participating?
 
Helen FeddemaConnect With a Mentor Commented:
Another possible source of import errors:  A single leading space in a column name.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Check EACH field for any special characters, although some will be allowed.  Definitely problematic are parens, slashes, dots ... and a few more.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Also ... be SURE no field names have a Line Feed & Carriage Return ... I just ran into that last week.

mx
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Here is one:

Original Loan Disbursed Amount (Gross)

parens
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
OK ... that's on a different tab ... but this is is a problem:

Pmt._Period_2_Start

see the period after Pmt    

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
All of these have Periods (dots)

Pmt._Period_1_End

Pmt._Period_1_Start

Pmt._Period_2_Start

Pmt._Period_2_End

Appears to be just these four on that tab.

Dashes and/or Underscores are not a problem.

mx
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Also note that sheet "2008_2009 Loans", has the field names in row *2*
...Not in Row 1 as is commonly expected.
This may cause issues as well.
0
 
DMKetcherConnect With a Mentor Author Commented:
I figured out the problem. I was copying repeating column heading groupings without making them unique. All is now fixed. Thanks!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The problems I identified are definitely part of the problem ...

mx
0
 
DMKetcherAuthor Commented:
THanks everyone!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.