• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

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
0
gigifarrow
Asked:
gigifarrow
  • 8
  • 4
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
Randy DownsOWNERCommented:
Your attached file shows as 0 bytes.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
FYI ... I'm unable to open the file.  If I change the extension to XLS .. it opens, but with a blank sheet.

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

 
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.

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 MVP, Access and Data Platform)Commented:
There is a Space before Tracking ... remove the space.

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

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

No can have parens or dots ...

Check ALL your column names ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
No can have parens or dots ... >> No can have parens or dots OR commas ... etc.

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

mx
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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