Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

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
0
DMKetcher
Asked:
DMKetcher
8 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
Also ... be SURE no field names have a Line Feed & Carriage Return ... I just ran into that last week.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Here is one:

Original Loan Disbursed Amount (Gross)

parens
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 CoachmanMIS 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
 
Helen FeddemaCommented:
Another possible source of import errors:  A single leading space in a column name.
0
 
DMKetcherAuthor 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 MVP, Access and Data Platform)Commented:
The problems I identified are definitely part of the problem ...

mx
0
 
DMKetcherAuthor Commented:
THanks everyone!!!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now