Exporting data from Excel to Access

I have an excel spreadsheet that I am trying to export to Access. However, it will not export. It tells me that The first row contains some data that cant't be used for valid access field names. In these cases, the wizard will automatically asign valid field names. Then it lets me continue. Unitl I push the finish button.

It tells me that "Tracking" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. I dont understand how Tracking is not a valid name. Enclosed is my excel spreadsheet.
CONUS-Shipment-Tracker-03-26-12-.xlsx
gigifarrowAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
There is a Space before Tracking ... remove the space.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
 
Randy DownsOWNERCommented:
Your attached file shows as 0 bytes.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
FYI ... I'm unable to open the file.  If I change the extension to XLS .. it opens, but with a blank sheet.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Check EACH field for any special characters, although some will be allowed.  Definitely problematic are parens, slashes, dots ... and a few more.

Also ... be SURE no field names have a Line Feed & Carriage Return ... I just ran into that last week.

And as noted by Helen ... a Space at the beginning of the column name ...

mx
0
 
gigifarrowAuthor Commented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Also:

Carrier  (FedEx,UPS, LANDSTAR,ROADWAY,CONWAY…)

No can have parens or dots ...

Check ALL your column names ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
space
0
 
Randy DownsOWNERCommented:
I am not using Office 2007 but I am able to save the 1st sheet as a .csv no problem. It does look like you have an unprintable character (e.g. space) on the end of tracking, so try deleting that.
0
 
Randy DownsOWNERCommented:
Also look for trailing characters on the rest of your 1 word fields.
0
 
Randy DownsOWNERCommented:
Quantity  Destination have a trailing character.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
No can have parens or dots ... >> No can have parens or dots OR commas ... etc.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I'm not sure trailing spaces are a problem ... as I think Access automatically drops them off during importing ...

mx
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.