Solved

Excel to MS Access 2007 Import Field Name Errors

Posted on 2012-03-26
10
256 Views
Last Modified: 2012-04-28
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
Comment
Question by:DMKetcher
10 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 357 total points
ID: 37769417
Check EACH field for any special characters, although some will be allowed.  Definitely problematic are parens, slashes, dots ... and a few more.

mx
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 357 total points
ID: 37769423
Also ... be SURE no field names have a Line Feed & Carriage Return ... I just ran into that last week.

mx
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 357 total points
ID: 37769428
Here is one:

Original Loan Disbursed Amount (Gross)

parens
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 357 total points
ID: 37769441
OK ... that's on a different tab ... but this is is a problem:

Pmt._Period_2_Start

see the period after Pmt    

mx
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 357 total points
ID: 37769443
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
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 71 total points
ID: 37771789
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
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 72 total points
ID: 37771848
Another possible source of import errors:  A single leading space in a column name.
0
 

Assisted Solution

by:DMKetcher
DMKetcher earned 0 total points
ID: 37772570
I figured out the problem. I was copying repeating column heading groupings without making them unique. All is now fixed. Thanks!
0
 
LVL 75
ID: 37772588
The problems I identified are definitely part of the problem ...

mx
0
 

Author Closing Comment

by:DMKetcher
ID: 37905324
THanks everyone!!!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now